ExcelDateIntermediate

NETWORKDAYS.INTL

Returns the number of whole workdays between two dates using custom weekend parameters.

Read the syntaxReview worked examplesOpen the spreadsheet app
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Open Spreadsheet Explorer

This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.

What the function does

Overview

Returns the number of whole workdays between two dates using custom weekend parameters.

The NETWORKDAYS.INTL function calculates the number of working days between a `ate` and an `ate`, allowing you to specify custom weekend days and an optional list of `holidays`. This function is invaluable for project management, calculating lead times, or tracking employee attendance, especially in global organizations with varied work schedules. Both `ate` and `ate` must be valid Excel dates. If `ate` is later than `ate`, the result will be negative. The `weekend` argument is highly flexible: it can be a number (1-7 for standard weekends, 11-17 for single-day weekends) or a 7-character string (e.g., "0000011" for Saturday/Sunday, where 0 means workday and 1 means weekend). The optional `holidays` argument is a range of dates to exclude. Correctly defining the `weekend` parameter is critical to ensure accurate workday counts for specific regional or company policies, making it a powerful tool for international business operations.

Quick reference

Syntax

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

Inputs

Arguments

start_dateThe start date for the period.
Example: A2
end_dateThe end date for the period.
Example: B2
weekend (optional)[Optional] A number or string indicating which days are weekend days. E.g., 1 (Sat/Sun), 11 (Sun only), or "0000110" (Fri/Sat).
Example: 1
holidays (optional)[Optional] An optional set of one or more dates to exclude from the workday calendar.
Example: C2:C5

Formula patterns

Examples

1

Counting workdays with custom weekend (Sunday only)

=NETWORKDAYS.INTL("2023-01-01", "2023-01-31", 11)
workday countcustom weekend
2

Counting workdays with custom weekend (Friday/Saturday) and holidays

=NETWORKDAYS.INTL(A2, B2, "0000110", C2:C5)
project managementinternational calendar

Avoid these issues

Common Errors

1

#VALUE!

Cause: The 'start_date', 'end_date', or any date in 'holidays' is not a valid Excel date, or the 'weekend' string is invalid.

Fix: Ensure all date arguments are valid and the 'weekend' argument follows the specified numeric or string format.

2

#NUM!

Cause: The date arguments are valid but fall outside Excel's supported date range (January 1, 1900, to December 31, 9999).

Fix: Adjust the 'start_date' or 'end_date' to fall within Excel's valid date range.

Platform support

Compatibility

Excel 2010+Google Sheets

Available in Excel 365 and 2010+.

Source: Microsoft Support

Common questions

Frequently Asked Questions

Returns the number of whole workdays between two dates using custom weekend parameters.

ate: The start date for the period. ate: The end date for the period. weekend: [Optional] A number or string indicating which days are weekend days. E.g., 1 (Sat/Sun), 11 (Sun only), or "0000110" (Fri/Sat). holidays: [Optional] An optional set of one or more dates to exclude from the workday calendar.

#VALUE!: Ensure all date arguments are valid and the 'weekend' argument follows the specified numeric or string format. #NUM!: Adjust the 'ate' or 'ate' to fall within Excel's valid date range.