|
<< Click to Display Table of Contents >> WORKDAY (date after x workdays) |
Syntax:
WORKDAY(StartDate, Days [, Holidays])
Description:
Returns the date that is x workdays before/after StartDate.
This function counts workdays only, Saturdays and Sundays are skipped. Optionally, you can specify 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, 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 (e.g. 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 working days after 10/1/2016 is therefore 10/13/2016.
The 10/3/2016 could be a holiday, however (for example, in Germany). If one wanted to take this into account, you would have to write:
WORKDAY("10/1/2016", 9, "10/3/2016") – and this results in 10/14 instead of 10/13, since the holiday on 10/3 fell on a weekday, so the count is skipped.
See also: