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 from start_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 to WORKDAY.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 working days, excluding specified weekend days and holidays.
TO_DATE
: Converts a provided number into 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 into 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.