NETWORKDAYS.INTL Function
Counts working days between two dates, with the weekend you choose.
Category
Date & Time
Available in
Excel 2010+, Microsoft 365
Returns
A whole number of days
Overview
NETWORKDAYS.INTL works like NETWORKDAYS but lets you set the weekend — essential for teams in regions with a Friday–Saturday weekend, or for six-day operations.
Use a weekend code or a 7-character mask starting on Monday (1 = day off).
Syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | The first date. |
| end_date | Yes | The last date. |
| weekend | Optional | 1 Sat–Sun (default), 2 Sun–Mon, 3 Mon–Tue, 4 Tue–Wed, 5 Wed–Thu, 6 Thu–Fri, 7 Fri–Sat, 11 Sun only, 12 Mon only … 17 Sat only — or a 7-character text mask such as "0000011" (Monday first, 1 = day off). |
| holidays | Optional | A range of dates to leave out. |
Examples
Example 1 — The same fortnight, three weekends
Monday, March 2 to Friday, March 13, 2026.
B2fx=NETWORKDAYS.INTL(DATE(2026,3,2),DATE(2026,3,13),1)
| A | B | |
|---|---|---|
| 1 | Weekend | Working days |
| 2 | 1 (Sat–Sun) | 10 |
| 3 | 7 (Fri–Sat) | 9 |
| 4 | 11 (Sun only) | 11 |
| 5 | "0000111" (Fri–Sun) | 8 |
Example 2 — Six-day warehouse with holidays
Only Sunday off, plus a holiday list.
=NETWORKDAYS.INTL(A2, B2, 11, $E$2:$E$5) Explain
Common mistakes
- The mask starts on the wrong day. The 7 characters run Monday to Sunday — "0000011" is a normal Saturday–Sunday weekend.
Notes
- Related functions: NETWORKDAYS, WORKDAY.INTL.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.