NETWORKDAYS.INTL function
Date1
The first date, as a sequential serial number.
Date2
The second date, as a sequential serial number.
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
The number of working days between the given two dates.
Returns the number of working days between two dates. 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 263, the number of working days between January 1, 2008, and January 1, 2009. Saturdays and Sundays are considered weekend days, due to the third parameter.
Returns 262, the number of working days between January 1, 2008, and January 1, 2009, when May 1, 2008, is explicitly excluded from the calculation. Saturdays and Sundays are considered weekend days, due to the third parameter.
Returns 314, the number of working days between January 1, 2008, and January 1, 2009, when May 1, 2008, is explicitly excluded from the calculation. Only Sundays are considered weekend days, due to the third parameter.