Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
NETWORKDAYS.INTL
NETWORKDAYS.INTL counts the number of whole working days between a start and end date, using a customisable weekend definition (numeric code or binary string) and an optional list of holidays to skip. Use it for SLA calculations, billing of hourly contractors, or any scenario with non-standard work weeks.
Excel
=NETWORKDAYS.INTL(DATE(2024,1,1),DATE(2024,1,31),11)Google Sheets
=NETWORKDAYS.INTL(DATE(2024,1,1),DATE(2024,1,31),11)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| StartDate | EndDate | WeekendCode | WorkDays |
| 2024-01-01 | 2024-01-31 | 11 | |
| 2024-03-01 | 2024-03-31 | 1 | |
| 2024-06-01 | 2024-06-30 | 7 | |
| 2024-11-01 | 2024-11-30 | 11 |
=NETWORKDAYS.INTL(DATE(2024,1,1),DATE(2024,1,31),11)→27
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Enter the start date in A2 and end date in B2 as proper Excel date values.
- 2Choose the weekend code: e.g. 1 = Sat–Sun (default), 7 = Fri–Sat, 11 = Sun only.
- 3Type =NETWORKDAYS.INTL(A2,B2,11) and optionally append a holiday range as the fourth argument.
Need a version for your data?
Try: “Count working days between project start and end dates where only Sunday is a weekend”