Quick Navigation
NETWORKDAYS.INTL Function
Summary
The NETWORKDAYS.INTL function calculates the number of working days between two dates, allowing customization of weekend days and exclusion of holidays. Unlike the standard NETWORKDAYS function, it supports international workweek patterns and flexible weekend definitions.
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| start_date | Date |
Yes | Start date for workday calculation |
| end_date | Date |
Yes | End date for workday calculation |
| weekend | Number/String |
No | Weekend pattern (1-17 or 7-char string) |
| holidays | Range/Array |
No | Dates to exclude as holidays |
Using the NETWORKDAYS.INTL Function
NETWORKDAYS.INTL excels in project planning, payroll calculations, and resource scheduling across different cultures. Use it when standard Saturday-Sunday weekends don't apply or when you need to account for regional holidays and custom workweeks.
Common NETWORKDAYS.INTL Examples
Standard Weekend Calculation
=NETWORKDAYS.INTL(DATE(2023,1,1),DATE(2023,1,31))Returns 22 workdays between Jan 1-31, excluding standard Sat-Sun weekends.
Past Date Range
=NETWORKDAYS.INTL(DATE(2023,1,31),DATE(2023,1,1))Returns -22 workdays when start_date > end_date.
Custom Weekend + Holidays
=NETWORKDAYS.INTL(DATE(2023,1,1),DATE(2023,2,1),7,{"1/2/2023","1/16/2023"})Friday-Saturday weekends (pattern 7) with 2 holidays excluded.
Weekend String Pattern
=NETWORKDAYS.INTL("1/1/2023","2/1/2023","0010001",A1:A2)Sunday-Wednesday weekends using string pattern with holiday range.
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: Date parameters out of valid Excel date range
Solution: Ensure dates are between 1/1/1900 and 12/31/9999
#VALUE!
Cause: Invalid weekend string length or characters
Solution: Use exactly 7 chars of 0s and 1s only
#VALUE!
Cause: Holidays contain non-date values
Solution: Verify holiday range contains valid dates
Notes
- Weekend numbers 1-17 cover common patterns; strings offer unlimited flexibility
- Works with date serial numbers, DATE functions, or cell references
- Holidays can be in any order and don't need to be sorted
- Partial days at start/end count as full workdays
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2007 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+