NETWORKDAYS.INTL Function

Counts working days between two dates, with the weekend you choose.

Category

Date & Time

Available in

Excel 2010+, Microsoft 365

Returns

A whole number of days

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

Overview

NETWORKDAYS.INTL works like NETWORKDAYS but lets you set the weekend — essential for teams in regions with a Friday–Saturday weekend, or for six-day operations.

Use a weekend code or a 7-character mask starting on Monday (1 = day off).

Syntax

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Arguments

ArgumentRequired?What it does
start_dateYesThe first date.
end_dateYesThe last date.
weekendOptional1 Sat–Sun (default), 2 Sun–Mon, 3 Mon–Tue, 4 Tue–Wed, 5 Wed–Thu, 6 Thu–Fri, 7 Fri–Sat, 11 Sun only, 12 Mon only … 17 Sat only — or a 7-character text mask such as "0000011" (Monday first, 1 = day off).
holidaysOptionalA range of dates to leave out.

Examples

Example 1 — The same fortnight, three weekends

Monday, March 2 to Friday, March 13, 2026.

B2fx=NETWORKDAYS.INTL(DATE(2026,3,2),DATE(2026,3,13),1)
AB
1WeekendWorking days
21 (Sat–Sun)10
37 (Fri–Sat)9
411 (Sun only)11
5"0000111" (Fri–Sun)8

Example 2 — Six-day warehouse with holidays

Only Sunday off, plus a holiday list.

=NETWORKDAYS.INTL(A2, B2, 11, $E$2:$E$5) Explain

Common mistakes

  • The mask starts on the wrong day. The 7 characters run Monday to Sunday — "0000011" is a normal Saturday–Sunday weekend.

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.