Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

WORKDAY function

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

StartDate

Number or { Number }

The start date as a sequential serial number.

Days

Number or { 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

{ Number } (optional)

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

Returns

Number or { Number }

A sequential serial number representing 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 sequential serial number 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 sequential serial number 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 sequential serial number 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 Friday) is considered a holiday.