NETWORKDAYS Function

Counts the working days between two dates.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A whole number of days

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

NETWORKDAYS counts Monday-to-Friday days between two dates, leaving out any holidays you list. Unlike WORKDAY, both the start and end dates count.

Use it for project durations, days to close a ticket or billable days in a month.

Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

Arguments

ArgumentRequired?What it does
start_dateYesThe first date (counted if it's a working day).
end_dateYesThe last date (counted if it's a working day).
holidaysOptionalA range of dates to leave out.

Examples

Example 1 — Working days per period

Count the working days in each project window.

C2fx=NETWORKDAYS(A2,B2)
ABC
1StartEndWorking days
23/2/20263/13/202610
33/1/20263/31/202622
44/1/20264/30/202622
=NETWORKDAYS(A2,B2) Explain

Example 2 — Leaving out holidays

Two holidays fall in this March project.

C2fx=NETWORKDAYS(A2,B2,$E$2:$E$3)
ABCDE
1StartEndWorking daysHolidays
23/2/20263/31/2026203/16/2026
33/17/2026
=NETWORKDAYS(A2,B2,$E$2:$E$3) Explain

Common mistakes

  • One more day than expected. NETWORKDAYS includes both ends. Subtract 1 if the start day shouldn't count.

Notes

Kyle Stott

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.