Calculates the end date after a specified number of working days.
Sample Usage
WORKDAY(DATE(1969,7,20), 4, A1:A10)
WORKDAY(A2, 10)
WORKDAY(40909, 4, B2:B17)
WORKDAY(40909, 30, {40909,40924})
Syntax
WORKDAY(start_date, num_days, [holidays])
-
start_date
- The date from which to begin counting. -
num_days
- The number of working days to advance fromstart_date
. If negative, counts backwards.- If
num_days
is not an integer, the decimal part is truncated. That is,WORKDAY(A2,1.9)
is equivalent toWORKDAY(A2,1)
.
- If
holidays
- [ OPTIONAL ] - A range or array constant containing the dates to consider holidays.
Notes
-
WORKDAY
does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,WORKDAY(10/10/2000,4)
is interpreted asWORKDAY(0.005,4)
, where the provided date is the quotient of 10 divided by 10 divided by 2000. -
WORKDAY
calculates the end date after a specified number of working days. To calculate the number of working days between two dates, useNETWORKDAYS
. WORKDAY
works similarly toWORKDAY.INTL
but only treats Saturday and Sunday as the weekend. UseWORKDAY.INTL
to use other days of the week as the weekend.
See Also
WORKDAY.INTL
: Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
TO_DATE
: Converts a provided number to a date.
NETWORKDAYS
: Returns the number of net working days between two provided days.
N
: Returns the argument provided as a number.
DATEVALUE
: Converts a provided date string in a known format to a date value.
DATE
: Converts a year, month, and day into a date.
Examples
Returns the end date after a specified number of working days.