Syntax. NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)
Definition. This function returns the number of workdays within the given time interval. Weekend days and any days that are specified as holidays are not considered as workdays.
Arguments
start_date (required). The date that represents the start of the time interval.
end_date (required). The date that represents the end of the time interval.
weekend (optional). A number or string indicating which days are weekends and should not be treated as workdays.
holidays (optional). An array of one or more dates defining nonworking days to exclude from the calculation, such as federal holidays and floating holidays. The array can be a cell range containing the dates or an array with serial numbers for the dates.
Background. Refer also to the NETWORKDAYS() function discussed previously. The Excel 2010 NETWORKDAYS.INTL() function also allows you to specify which days are weekends and therefore are not counted. If you specify a number or string for the weekend, use the values shown in Table 7-2.
Table 7-2. Values for the NETWORKDAYS.INTL() Function
Number | Weekdays | String |
|---|---|---|
1 (or no value) | Saturday, Sunday | 0000011 |
2 | Sunday, Monday | 1000001 |
3 | Monday, Tuesday | 1100000 |
4 | Tuesday, Wednesday | 0110000 |
5 | Wednesday, Thursday | 0011000 |
6 | Thursday, Friday | 0001100 |
7 | Friday, Saturday | 0000110 |
11 | Sunday | 0000001 |
12 | Monday | 1000000 |
13 | Tuesday | 0100000 |
14 | Wednesday | 0010000 |
15 | Thursday | 0001000 |
16 | Friday | 0000100 |
17 | Saturday | 0000010 |
You can use any combination except 1111111. A 0 indicates a workday, and a 1 indicates a work-free day.
Example. Assume that a project is planned from December 12, 2008, through June 2, 2009. You have to calculate the number of workdays in this timeframe, excluding holidays. The formula
=NETWORKDAYS.INTL("12/12/10","06/02/11",1,{"12/25/10","01/01/11","01/17/11","02/21/11
","05/30/2011","07/04/11"})returns 121 workdays for the project. Note that in the formula, holidays are enclosed in braces and not in parentheses.