Excel NETWORKDAYS Function: Complete Guide (2026)
Home›Functions›Date & Time›NETWORKDAYS
ExcelFunction Reference⏱ 6 min read

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

NETWORKDAYS(start_date, end_date, [holidays])
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
ArgumentTypeDescription
start_date RequiredDateThe start of the period. Included in the count if it's a weekday.
end_date RequiredDateThe end of the period. Included in the count if it's a weekday.
holidays OptionalRange or arrayDates to exclude from the count. Typically a named range on a "Holidays" sheet.
weekend Optional (INTL only)Number or stringCustom weekend pattern. Number code 1-17 or 7-character binary string.

Basic examples

Workdays between two dates

=NETWORKDAYS("2026-09-01", "2026-09-30")
Result: 22 (all weekdays in September 2026)

With holidays excluded

=NETWORKDAYS("2026-12-01", "2026-12-31", HolidayList)
Result: ~21 depending on how many US holidays fall in December

Common uses

1. Time-to-deadline in business days

Working days until a due date

=NETWORKDAYS(TODAY(), A1, HolidayRange)
Returns 0 or negative if the deadline is past.

2. SLA response tracking

Ticket age in business days

=NETWORKDAYS(ticketOpenedDate, IF(status="Closed", closedDate, TODAY()), Holidays)
For open tickets, measures age. For closed, measures time-to-resolve.

3. Contractor billable days

Workdays in a project

=NETWORKDAYS(projectStart, projectEnd, ObservedHolidays)
Multiply by daily rate for total invoice.

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)
Applied to a column of tickets. Then chart the distribution.

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

CodeWeekend days
1 (default)Saturday, Sunday
2Sunday, Monday
3Monday, Tuesday
......
7Friday, Saturday (Middle East)
11Sunday only
17Saturday 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")
Position 7 (Sunday) is 1 = weekend. All other days = workday.

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.

  1. Create the Holidays sheet with dates in column A
  2. Select the date range → Formulas → Define Name → "HolidayList"
  3. 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

FunctionCountsBest for
NETWORKDAYS(a, b)Weekdays only, inclusive on both endsBusiness day math, SLAs
DATEDIF(a, b, "D")All calendar days, exclusive of endAge, calendar duration
b - aCalendar days, exclusive of endSame as DATEDIF "D"

Common pitfalls

Both dates inclusive

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.

Holidays as text

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.

Different holidays per region

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.

Fiscal calendar support

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

Related

WORKDAY

The reverse — returns a date N workdays away.

Related

DATEDIF

Calendar-day differences (includes weekends).

Related

WEEKDAY

Test individual days for weekend/weekday.

Related

EOMONTH

Anchor NETWORKDAYS to month boundaries.

Excel Wizard

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.