|
<< Click to Display Table of Contents >> WORKDAY (date after x workdays) |
Syntax:
WORKDAY(StartDate, Days [, Holidays])
Description:
This determines the date that is x workdays before or after the StartDate.
This function counts workdays only, thus skipping Saturdays and Sundays. You also have the option of specifying a list of holidays to be skipped as well (see Holidays parameter).
StartDate is the start date.
Days is the number of workdays. A positive value will return a date in the future, while a negative value will return a date in the past.
Holidays (optional) is a cell range or an array containing a list of dates to be skipped (for example, holidays). (This is usually done using a cell range or an array containing the corresponding date values.)
Example:
WORKDAY("10/1/2016", 9) returns 10/13/2016.
The date that comes 9 work days after 10/1/2016 is thus 10/13/2016.
However, 10/3/2016, for example, was a holiday in Germany. If you wanted to take this into account, you would have to write:
WORKDAY("10/1/2016", 9, "10/3/2016") – which results in 10/14 instead of 10/13, since the holiday on 10/3 fell on a weekday and thus is skipped in the count.
See also: