WORKDAY
Description
Returns a number representing the date that is the specified number of work days after the specified start_date.
Syntax
WORKDAY(
start_date
,
days
, [
holidays
])
- start_date: The date to start counting from. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- days: The number of work days to add to the start_date.
- holidays: The list of dates to exclude from the work day count. Workday recommends using a cell reference to specify the dates instead of entering them as text, to ensure reliable results.
Example
Formula | Result |
|---|---|
=WORKDAY("11/20/2017",30) | 1/1/2018 |
=WORKDAY("11/20/2017",27,{"11/23/2017", "11/24/2017",
"12/25/2017"}) | 1/1/2018 |