These docs are for v1.0. Click to read the latest docs for v1.2.

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 NETWORKDAYS function calculates a range inclusive of the start date, WORKDAY excludes 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

ArgumentTypeDescription
startDateThe beginning date to use for the calculation
workdaysNumberThe 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.
holidaysArray(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