WORKDAY.INTL function

WORKDAY.INTL(startDate, days, weekend?, holidays?) WORKDAY.INTL(startDate; days; weekend?; 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.

weekend — Number or { Number } (optional)

A number specifying the day or days of the week that are considered weekend days. Refer to the table for more information on this parameter. If omitted, Saturday and Sunday are considered weekend days.

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.

The day or days of the week that are considered weekend days can be customized by specifying the weekend parameter. Use this table to determine what number to use:

Valid values for the weekend parameter
Value Meaning
1 (default) Saturday, Sunday
2 Sunday, Monday
3 Monday, Tuesday
4 Tuesday, Wednesday
5 Wednesday, Thursday
6 Thursday, Friday
7 Friday, Saturday
11 Sunday only
12 Monday only
13 Tuesday only
14 Wednesday only
15 Thursday only
16 Friday only
17 Saturday only

Examples

WORKDAY.INTL(DATE(2021, 2, 17), 2, 1)WORKDAY.INTL(DATE(2021; 2; 17); 2; 1)

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. Saturdays and Sundays are considered weekend days, due to the third parameter.

WORKDAY.INTL(DATE(2021, 2, 17), 3, 1)WORKDAY.INTL(DATE(2021; 2; 17); 3; 1)

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. Saturdays and Sundays are considered weekend days, due to the third parameter.

WORKDAY.INTL(DATE(2021, 2, 17), 3, 17)WORKDAY.INTL(DATE(2021; 2; 17); 3; 17)

Returns a sequential serial number representing February 21, 2021, a Sunday. February 17, 2021, is a Wednesday, and advancing that date by three working days returns the following Sunday, because the calculation skips over weekends and holidays. Only Saturdays are considered a weekend day, due to the third parameter.

WORKDAY.INTL(DATE(2021, 2, 17), 3, 1, { DATE(2021, 2, 18) })WORKDAY.INTL(DATE(2021; 2; 17); 3; 1; { 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. Saturdays and Sundays are considered weekend days, due to the third parameter.