WORKDAY function

WORKDAY (StartDate, Days, Holidays?) WORKDAY (StartDate; Days; Holidays?)

StartDate

Temporal Temporal

The start date.

Days

Number Number

The number of working days to set back or advance the start date. A positive number advances the start date and a negative number sets it back.

Holidays

An array of dates representing holidays, which are not considered working days. If omitted, only weekends are excluded from the calculation.

Returns

Temporal Temporal

A date advanced or set back a number of working days.

Returns a date advanced or set back a number of working days. Weekends are excluded from the calculation, as are the holidays given as the third parameter. To customize what days are considered weekend days, use the WORKDAY.INTL function instead.

Examples

WORKDAY ( DATE (2021, 2, 17), 2)

WORKDAY ( DATE (2021; 2; 17); 2)

Returns a date representing February 19, 2021, a Friday. February 17, 2021, is a Wednesday, and advancing that date by two working days returns the following Friday.

WORKDAY ( DATE (2021, 2, 17), 3)

WORKDAY ( DATE (2021; 2; 17); 3)

Returns a date representing February 22, 2021, a Monday. February 17, 2021, is a Wednesday, and advancing that date by three working days returns the following Monday, because the calculation skips over weekends and holidays.

WORKDAY ( DATE (2021, 2, 17), 3, { DATE (2021, 2, 18) })

WORKDAY ( DATE (2021; 2; 17); 3; { DATE (2021; 2; 18) })

Returns a date representing February 23, 2021, a Tuesday. February 17, 2021, is a Wednesday, and advancing that date by three working days returns the following Tuesday, because the calculation skips over weekends and holidays and February 18 (a Thursday) is considered a holiday.