WORKDAY
Given a start date, finds the date a specified number of working days later. A list of holidays can optionally be provided, indicating the given dates are not working days.
While the
NETWORKDAYSfunction calculates a range inclusive of the start date,WORKDAYexcludes the start date. For example,WORKDAY("2020-04-01", NETWORKDAYS("2020-04-01", "2020-04-01"))will return 2020-04-02.
Syntax
=WORKDAY(start, workdays, holidays)
Arguments
| Argument | Type | Description |
|---|---|---|
| start | Date | The beginning date to use for the calculation |
| workdays | Number | The number of working days to add to the start date. If the value provided is not a whole number the formula will round the value down to the nearest whole number. |
| holidays | Array(Date) | (Optional) Dates to exclude from the count of working days |
Examples
=WORKDAY("2020-04-01", 7)→2020-04-10
Returns the date 7 working days (Mon-Fri) later
=WORKDAY("2020-04-08", -5)→2020-04-01
The function accepts negative values and will return a date before the date provided
=WORKDAY("2020-04-01", 3, ["2020-04-03", "2020-03-31", "2020-04-16"])→2020-04-07
Holidays are excluded. Holidays outside the interval or on weekends are ignored
Updated 8 months ago