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.

[Example:

WORKDAY(DATE(2006,1,1),0) results in a serial value corresponding to 1-Jan-2006
WORKDAY(DATE(2006,1,1),10) results in a serial value corresponding to 13-Jan-2006
WORKDAY(DATE(2006,1,1),-10) results in a serial value corresponding to 19-Dec-2005
WORKDAY(DATE(2006,1,1),20,{"2006/1/2","2006/1/16"}) results in a serial value corresponding to 31-Jan-2006

end example]