NETWORKDAYS.INTL function
Quick answer
NETWORKDAYS.INTL counts the working days between two dates, like NETWORKDAYS, but lets you say which days are the weekend: Friday and Saturday, Sunday only, or any pattern written as a seven-character string such as "0000011".
- Syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])- Most common use
=NETWORKDAYS.INTL(A2,B2)returns 22 (Monday to Friday in March 2026: 22)
Use it for teams, countries or shifts that don't work Monday to Friday.
- Available in
- Excel 2010 and later
- Category
- Date functions
- Returns
- A whole number of working days; negative if the end date is before the start.
- Google Sheets
- Works the same in Google Sheets.
Syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
| Argument | Required? | What it is |
|---|---|---|
start_date | Required | The first day of the period. |
end_date | Required | The last day. Both count when they are working days. |
weekend | Optional | Optional: a code (1 Saturday–Sunday, 7 Friday–Saturday, 11 Sunday only, 17 Saturday only…) or seven 0s and 1s from Monday to Sunday, 1 for days off. |
holidays | Optional | Optional: a range of dates to skip. |
Examples
Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.
| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | =NETWORKDAYS.INTL(A2,B2) | 22 | Monday to Friday in March 2026: 22 |
| E3 | =NETWORKDAYS.INTL(A2,B2,7) | 23 | Sunday to Thursday, with Friday and Saturday off: 23 |
| E4 | =NETWORKDAYS.INTL(A2,B2,"0000011",C2) | 21 | Saturday and Sunday off, written as a string, minus the holiday: 21 |
Try it live
This is the sample sheet. Change any number or text, or edit a formula, and the results update.
Show the sample data as a table
| Start | End | Holiday | Result | |
| 3/1/2026 | 3/31/2026 | 3/20/2026 | 22 | |
| 23 | ||||
| 21 |
Practice NETWORKDAYS.INTL
Graded instantly, then re-checked on changed data.
Six-day weeks
D2, count the working days from A2 to B2, with Sunday the only day off and the holidays in F2:F3 excluded. Fill down to D6.Common mistakes
| What you see | Why, and how to fix it |
|---|---|
| #VALUE! | The weekend string isn't seven characters of 0 and 1, or every day is marked as weekend. |
| #NUM! | The weekend code isn't one of 1–7 or 11–17. |
| One day too many | Both the start and end dates count when they are working days. |
Tips
- Read a weekend string from Monday to Sunday: "0000011" means Saturday and Sunday off.
Questions
How do I count working days with a Friday–Saturday weekend?
=NETWORKDAYS.INTL(A2,B2,7). Code 7 marks Friday and Saturday as the weekend.
How do I count Mondays to Saturdays?
Use 11, Sunday only: =NETWORKDAYS.INTL(A2,B2,11).
Updated Checked by running: every formula on this page was run by our formula engine on .