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

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