How to Use the NETWORKDAYS.INTL Function in Excel to Calculate Working Days with Custom Weekends

Project managers, financial analysts, and payroll administrators frequently need to compute the exact number of working days between two milestone dates. While the legacy NETWORKDAYS function assumes every organisation observes a standard Saturday and Sunday weekend, modern business schedules often follow non-standard operating schedules—such as four-day work weeks, retail shifts, or international workweeks (such as Sunday to Thursday in the Middle East). The NETWORKDAYS.INTL function in Microsoft Excel resolves this limitation by supporting fully customisable weekend definitions and statutory holiday exclusions.

Syntax and Parameter Breakdown

The syntax for NETWORKDAYS.INTL consists of four arguments:

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

• start_date: The initial date from which calculation commences (inclusive).
• end_date: The final date of the project timeline (inclusive).
• [weekend]: (Optional) A numerical code or custom 7-character binary string defining which days of the week are non-working days. Defaults to 1 (Saturday and Sunday).
• [holidays]: (Optional) A range of cells or array constant containing specific dates to exclude from the total count as paid public holidays.

Preset Weekend Number Codes in Excel

You can specify predefined weekend patterns using integer identifiers:

Code	Weekend Days Excluded	Ideal Operating Scenario
1	Saturday, Sunday	Standard western corporate business schedule
2	Sunday, Monday	Hospitality and service industries
7	Friday, Saturday	Middle Eastern commercial markets
11	Sunday only	Six-day retail and manufacturing operations
17	Saturday only	Alternative six-day shift schedules

Using Custom 7-Character String Weekend Masks

For flexible or non-contiguous schedules—such as a 4-day working week where employees work Monday through Thursday, with Friday, Saturday, and Sunday off—Excel accepts a 7-character text string composed strictly of zeros (0) and ones (1). Each character represents a consecutive day starting with Monday:

• 0 = Working day
• 1 = Non-working day (weekend)

Example String Masks:

• "0000111": Monday–Thursday working; Friday, Saturday, and Sunday off.
• "1010101": Alternating shift days (Tuesday, Thursday, Saturday working).
• "0000000": Seven-day operations (no weekends, only holiday exclusions apply).

Practical Example: Calculating Working Days for a Shift Project

Suppose you have the following data in an Excel worksheet:

• Cell A2 (Start Date): 2026-09-01
• Cell B2 (End Date): 2026-09-30
• Cells D2:D4 (Company Holidays): 2026-09-07, 2026-09-21

Formula 1: Standard Middle East Weekend (Friday & Saturday Off)

To compute net working days where Friday and Saturday constitute the weekend:

=NETWORKDAYS.INTL(A2, B2, 7, D2:D4)

Formula 2: Four-Day Work Week (Monday to Thursday)

To compute net working days using the custom string mask:

=NETWORKDAYS.INTL(A2, B2, "0000111", D2:D4)

Tips for Preventing Date Formatting Errors

To avoid common formula calculation bugs:

• Avoid Hardcoded Text Dates: Never type date strings directly like "01/09/2026" into formulas because regional date settings can confuse months and days. Reference cells containing real serial dates or wrap them with the DATE(year, month, day) function:

  =NETWORKDAYS.INTL(DATE(2026,9,1), DATE(2026,9,30), "0000111", D2:D4)

• Chronological Order: If the start_date occurs after the end_date, NETWORKDAYS.INTL returns a negative value representing the elapsed duration in reverse.

Mastering NETWORKDAYS.INTL enables precise project velocity tracking, accurate payroll scheduling, and realistic delivery forecasts tailored to any operational work schedule worldwide.