Excel Function : WORKDAY
Category
Date and time
Description
Returns the serial number of the date before or after a specified number of workdays
Microsoft Excel Reference Page
https://support.office.com/en-us/article/WORKDAY-function-f764a5b7-05fc-4494-9486-60d494efbf33
Syntax and Description of the WORKDAY Excel Function
The WORKDAY function syntax is as follows: WORKDAY(start_date, days, [holidays]) start_date is the start date for the calculation. days is the number of days you want to add to the start date, excluding weekends and holidays. holidays is an optional list of dates to exclude from the calculation.
About WORKDAY Excel Function
The WORKDAY function returns a date that is the indicated number of workdays before or after a given start date. WORKDAY(start_date, days, [holidays]) The start_date argument is a date that represents the start date. The days argument is the number of workdays before or after the start date. A positive value for days yields a future date; a negative value yields a past date. The holidays argument is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. If the start_date is not a workday, WORKDAY adjusts the return date to the next workday.
