Excel NETWORKDAYS Function: Complete Guide
NETWORKDAYS counts working days between two dates — automatically excluding Saturdays and Sundays. Add a holiday range and it excludes those too. For non-standard weekends (Fri-Sat, 6-day workweeks), use the INTL variant. Essential for finance, SLAs, and project timelines.
Syntax
| Argument | Type | Description |
|---|---|---|
start_date Required | Date | The start of the period. Included in the count if it's a weekday. |
end_date Required | Date | The end of the period. Included in the count if it's a weekday. |
holidays Optional | Range or array | Dates to exclude from the count. Typically a named range on a "Holidays" sheet. |
weekend Optional (INTL only) | Number or string | Custom weekend pattern. Number code 1-17 or 7-character binary string. |
Basic examples
Workdays between two dates
=NETWORKDAYS("2026-09-01", "2026-09-30")
With holidays excluded
=NETWORKDAYS("2026-12-01", "2026-12-31", HolidayList)
Common uses
1. Time-to-deadline in business days
Working days until a due date
=NETWORKDAYS(TODAY(), A1, HolidayRange)
2. SLA response tracking
Ticket age in business days
=NETWORKDAYS(ticketOpenedDate, IF(status="Closed", closedDate, TODAY()), Holidays)
3. Contractor billable days
Workdays in a project
=NETWORKDAYS(projectStart, projectEnd, ObservedHolidays)
4. Days until end of quarter
Business days remaining in Q3
=NETWORKDAYS(TODAY(), DATE(2026, 9, 30))
5. Response time distribution
SLA histogram
=NETWORKDAYS(A2, B2)
Non-standard weekends with NETWORKDAYS.INTL
For weekends other than Saturday-Sunday, use the INTL variant with a weekend code.
Method 1: Weekend number codes
| Code | Weekend days |
|---|---|
| 1 (default) | Saturday, Sunday |
| 2 | Sunday, Monday |
| 3 | Monday, Tuesday |
| ... | ... |
| 7 | Friday, Saturday (Middle East) |
| 11 | Sunday only |
| 17 | Saturday only |
Middle East weekend (Fri-Sat)
=NETWORKDAYS.INTL("2026-09-01", "2026-09-30", 7)
Method 2: 7-character binary string
For custom weekends. Each character represents a day starting Monday. 1 = weekend, 0 = workday.
Only Sunday off (6-day workweek)
=NETWORKDAYS.INTL(start, end, "0000001")
3-day weekend (Fri-Sat-Sun)
=NETWORKDAYS.INTL(start, end, "0000111")
Setting up a holidays list
Best practice: keep holidays on a separate sheet named "Holidays" with two columns (Date, Description). Use a named range so formulas reference the list clearly.
- Create the Holidays sheet with dates in column A
- Select the date range → Formulas → Define Name → "HolidayList"
- Reference in formulas:
=NETWORKDAYS(A1, B1, HolidayList)
Update the holiday list once per year — every formula that uses HolidayList reflects the change.
NETWORKDAYS vs. DATEDIF
| Function | Counts | Best for |
|---|---|---|
NETWORKDAYS(a, b) | Weekdays only, inclusive on both ends | Business day math, SLAs |
DATEDIF(a, b, "D") | All calendar days, exclusive of end | Age, calendar duration |
b - a | Calendar days, exclusive of end | Same as DATEDIF "D" |
Common pitfalls
NETWORKDAYS counts both endpoints when they're weekdays. Monday to Monday = 5 days (Mon, Tue, Wed, Thu, Fri, Mon = including both endpoints = 5 workdays including Monday of both weeks). If you want an exclusive count, subtract 1.
The holidays argument needs real dates. If your holiday list has text-formatted dates, NETWORKDAYS silently ignores them. Convert with DATEVALUE or reformat as dates.
Business days depend on where you operate. Maintain separate holiday lists per region and use them in the appropriate formulas. NETWORKDAYS(a, b, USHolidays) and NETWORKDAYS(a, b, UKHolidays) can produce different results for the same date range.
NETWORKDAYS doesn't understand fiscal quarters — it only counts days. Combine with EOMONTH, DATE, or IF logic to constrain to fiscal periods.
NETWORKDAYS in Google Sheets
Google Sheets has both NETWORKDAYS and NETWORKDAYS.INTL. Same syntax, same behavior. Sheets also has the same weekend codes for INTL.
Related functions
Business day math without the setup
NETWORKDAYS needs a holiday list, and NETWORKDAYS.INTL needs custom weekend codes. Excel Wizard can generate the right formula for your region — pull a US, UK, or Middle East holiday list and use the right weekend code without manual lookups.
Install Excel Wizard →Frequently asked questions
What does NETWORKDAYS do in Excel?
NETWORKDAYS counts working days between two dates, excluding Saturdays and Sundays. Both start and end dates are inclusive.
How do I exclude holidays from NETWORKDAYS?
Pass a range of holiday dates as the third argument: =NETWORKDAYS(A1, B1, HolidayRange).
How do I count workdays with a non-standard weekend?
Use NETWORKDAYS.INTL with a weekend code (1-17) or a 7-character binary string. Perfect for Middle East (Fri-Sat) or 6-day weeks.
Does NETWORKDAYS include the start and end dates?
Yes — both endpoints are counted if they're weekdays. This inclusive counting matches how humans think about business days.