Returns the date which is the specified number of work days before or after another specified date.
Syntax
 Copy Code
|
|---|
WORKDAY( Date date, Integer offset, [ReferenceOrArray holidays], [ReferenceOrArray weekends] ) → Date |
Parameters
- date
- Required. The date to offset.
- offset
- Required. The number of work days to offset.
- holidays
- Optional. A list of dates, that specifying the holiday dates that should not be considered work days.
- weekends
- Optional. A list of logical values that specify which days of the week are working days.
Remarks
This function returns the date, which is the specified amount of work days before or after date. If offset is negative, WORKDAY returns a past date; if offset is positive, WORKDAY returns a future date. If holidays is specified, it can be an array or a cell reference, containing dates or serial numbers of dates, that should be regarded as nonworking days. If weekends is specified, it can be an array or a cell reference, containing logical values. The length of weekends must be exactly 7; otherwise, the function will return #VALUE!. Each value in weekends indicates whether the corresponding day of the week (1 to 7 for Sunday through Saturday) should be regarded as a weekend. TRUE indicates a weekend, FALSE indicates a working day. If weekends is omitted, Saturday and Sunday are counted as weekends.
Example
| Formula
Copy Code
|
|---|
=WORKDAY(TODAY(),10) |
See Also
Function Reference
EDATE Function
EOMONTH Function
NOW Function