WORKDAY
Syntax:
WORKDAY ( start-date , day-offset [ , holidays ] )
Description: Computes the serial value of the date that is day-offset working days offset from start-date. Weekend days and any holidays specified by holidays are not considered as working days.
Arguments:
Name |
Type |
Description |
|---|---|---|
start-date |
number |
The start date, truncated to integer. |
day-offset |
number |
The number of working days before or after start-date. A positive value yields a future date; a negative value yields a past date; a zero value yields the date start-date. day-offset is truncated to an integer. |
holidays |
reference, array |
An optional set of one or more dates that are to be excluded from the working day calendar. holidays shall be a range of cells that contain the dates, or an array constant of the serial values that represent those dates. The ordering of dates or serial values in holidays can be arbitrary. |
Return Type and Value: number – The serial value of the date that is day-offset working days offset from start-date, excluding the specified holidays.
However, if
start-date is out of range for the current date base value,
#NUM!is returned.Any date in holidays is out of range for the current date base value,
#NUM!is returned.start-date plus day-offset yields an invalid date,
#NUM!is returned.