It is use to calculates the number of working days between two dates while excluding:
- Custom-defined weekends (not limited to Saturday/Sunday)
- Specified holidays
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments
- start_date (required): First day of the period.
- end_date (required): Last day of the period.
- weekend (optional): Defines non-working days. Options:
- Number codes (1-7, 11-17): Predefined weekend combinations (see table below).
- 7-digit string: Custom weekly off-days (e.g., « 0000011 » = Saturday/Sunday).
- Default: 1 (Saturday/Sunday off).
- holidays (optional): Additional non-working dates (cell range or array).
Weekend Codes Reference
| Number | Weekend Days | String Equivalent |
| 1 (default) | 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 only | « 0000001 » |
| 12 | Monday only | « 1000000 » |
| … | … | … |
| 17 | Saturday only | « 0000010 » |
Note: Strings use 1 for off-days and 0 for workdays (e.g., « 0101000 » = Monday/Wednesday off).
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.
Notes
- Error Handling: Returns #VALUE! for invalid dates or text entries.
- Flexibility: Supports any weekend pattern except « 1111111 » (no workdays).
- Pro Tip: Name your holiday range (e.g., Holidays) for cleaner formulas.