Returns a number that represents a date that is the indicated number of working days before or after a date (the starting 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.
This function was replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. This function is still available for compatibility with earlier versions of Excel. However, if backward compatibility is not required, you should consider using the new functions from now on, because they more accurately describe their functionality.
For more information about the new function, see WORKDAY.INTL function.
Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use =DATE(2008,5,23) for the 23rd day of May, 2008. Problems might occur if dates are entered as text.
A date that represents the first, or starting, date of the period.
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.
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 that contain the dates or an array constantA set of data used to build single formulas that produce multiple results or that operate on a group of arguments arranged in rows and columns. Excel has two kinds of arrays: array ranges and array constants. An array range is a rectangular area of cells that share a common formula; an array constant is a specially arranged group of constants that's used as an argument in a formula. of the serial numbers that represent the dates.
To view the serial number as a date, select the cell, and then on the View menu, click Formatting Palette. Under Number, on the Format pop-up menu, click Date.
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.
|Note To convert the range of cells used for holidays in the last formula of the example into an array constant, select A4:A6 and then press ⌘+=.|