NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend

📎 This article includes 1 downloadable practice file ↓

DateLevel: ExpertAvailable in: Excel 2010+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. NETWORKDAYS.INTL in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

NETWORKDAYS.INTL counts working days when your weekend is not Saturday–Sunday — a Sunday-only week, or a Friday–Saturday weekend in the Gulf.

Syntax

=NETWORKDAYS.INTL(start, end, [weekend], [holidays])

Argument	What it means
weekend	Code (11 = Sunday only) or a 7-character mask “0000011” starting Monday, 1 = off.

Examples

Example 1

=NETWORKDAYS.INTL(A2, B2, 11, Holidays)

Six-day week with Sundays off, minus holidays.

Example 2

=NETWORKDAYS.INTL(A2, B2, "0000101")

Off on Friday and Sunday.

NETWORKDAYS.INTL in practice

Where you will use it

• Working days with Sunday-only weekends
• Shops closed on Tuesday
• Six-day work weeks

Worked example

Working days in October 2026.

Weekend code	Formula	Result
11	=NETWORKDAYS.INTL(DATE(2026,10,1),DATE(2026,10,31),A2)	27
1	=NETWORKDAYS.INTL(DATE(2026,10,1),DATE(2026,10,31),A3)	22
0000011	=NETWORKDAYS.INTL(DATE(2026,10,1),DATE(2026,10,31),A4)	22

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Weekend codes	11 = Sunday only, 1 = Sat+Sun, string = custom (1 = off)
Holidays	Add a list as the 4th argument

Related functions

NETWORKDAYS · WORKDAY.INTL

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Date & Time guides →

TIMEVALUE Function in Excel: Text Time to Real TimeDateLevel: IntermediateAvailable in: Excel 2007+TIMEVALUE turns text like "2:45 PM" into a real time…DATEVALUE Function in Excel: Convert Text Dates Into Real DatesDATEVALUE turns a date written as text into a real date number. It follows…MINUTE Function in Excel: Minute From a TimeDateLevel: BeginnerAvailable in: Excel 2007+MINUTE returns 0–59 from a time.Syntax=MINUTE(serial_number)ArgumentWhat it.SECOND Function in Excel: Second From a TimeDateLevel: BeginnerAvailable in: Excel 2007+SECOND returns 0–59. Mostly used to strip seconds from machine.

📎 Practice files for this article

• 📗
  Practice workbook: Dates & times22 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 34 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.