WORKDAY

Description Returns the date that is a specified number of days before or after a specified date, not counting weekends and specified holidays.

Syntax WORKDAY (start_date, days [, holidays])

Argument Description

start_date The date from which calculations will start. Dates in the argument list must be entered as text, with quotation marks. Decimal values are truncated to integers.

days The number of days before or after start_date. Enter a negative number to find days before, a positive number to find days after. Decimal values are truncated to integers.

[holidays] Optional. A range reference or array constant containing a list of dates that represent holidays. The dates specified in holidays will not be counted as workdays in the function's computation. Dates in array references must be entered as text, with quotation marks. Decimal values are truncated to integers.

Argument	Description
start_date	The date from which calculations will start. Dates in the argument list must be entered as text, with quotation marks. Decimal values are truncated to integers.
days	The number of days before or after start_date. Enter a negative number to find days before, a positive number to find days after. Decimal values are truncated to integers.
[holidays]	Optional. A range reference or array constant containing a list of dates that represent holidays. The dates specified in holidays will not be counted as workdays in the function's computation. Dates in array references must be entered as text, with quotation marks. Decimal values are truncated to integers.

Examples This function returns 1/14/93:

WORKDAY("12/15/92",20,{"12/24/92","12/25/92","1/1/93"})

This function returns 6/29/99:

WORKDAY("7/14/99",-10,{"7/5/99"})

See Also NETWORKDAYS, WEEKDAY