The Excel NETWORKDAYS.INTL function counts working days between two dates with a configurable weekend — the flexible cousin of NETWORKDAYS for non-standard work weeks across regions.
Syntax
| Argument | Description | |
|---|---|---|
start_date | Required | First date (counted). |
end_date | Required | Last date (counted). |
weekend | Optional | Weekend code (1–17) or a 7-character mask like "0000011". |
holidays | Optional | Optional dates to exclude. |
How to use it
Both endpoints are counted (inclusive). The weekend argument takes the same codes and 7-character masks as WORKDAY.INTL. Add a holidays range to subtract company holidays too:
For a fixed Saturday–Sunday weekend, plain NETWORKDAYS is simpler.
Try it: interactive demo
Adjust the input and watch the formula and result update.
Tips & gotchas
Count working days with a configurable weekend - any region's work week. Format result cells as Date or Time so they don’t display raw serial numbers.
Practice workbook
Frequently asked questions
Are both dates counted?
How do I set a custom weekend?
NETWORKDAYS vs NETWORKDAYS.INTL?
Which versions?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class