WORKDAY

Returns a number that represents a date that is the indicated number of working days before or after start_date. Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed. To view the number as a date, click Cells on the Format menu, click Date in the Category box, and then click a date format in the Type box.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

WORKDAY(start_date,days,holidays)

Start_date   is a date that represents the start date.

Days   is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.

Holidays   is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells or an array constant of the numbers that represent the dates.

Remarks

• If any argument is nonnumeric, WORKDAY returns the #VALUE! error value.
• If start_date is not a valid date, WORKDAY returns the #NUM! error value.
• If start_date plus days yields an invalid date, WORKDAY returns the #NUM! error value.
• If days is not an integer, it is truncated.

Examples

WORKDAY(DATEVALUE("01/03/91"), 5) equals 33248 or 01/10/91

If January 7, 1991 and January 8, 1991 are holidays, then:
WORKDAY(DATEVALUE("01/03/91"), 5, {33245, 33246}) equals 33252
or 01/14/91