WORKDAY.INTL function
StartDate
The start date as a sequential serial number.
Days
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
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
An array of sequential serial numbers representing holidays, which are not considered working days. If omitted, only weekends are excluded from the calculation.
Returns
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:
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
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.
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.
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.
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.