Google Sheets Function

NETWORKDAYS.INTL

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

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

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

This function calculates the total number of workdays between a start date and an end date, excluding weekends and specified holidays. Unlike the standard NETWORKDAYS function, it allows you to define which days of the week are considered weekends.

Arguments

start_daterequiredThe starting date of the period.
end_daterequiredThe ending date of the period.
weekendoptionalA number or string indicating which days are weekends (default is 1, Saturday and Sunday).
holidaysoptionalAn optional range of dates to be excluded from the working day count.

Examples

=NETWORKDAYS.INTL("2023-01-01", "2023-01-31", 11)

Result: 26

Calculates workdays in January 2023 where only Sunday is a weekend (represented by 11).

FAQ

What does the weekend argument 11 mean?

The value 11 indicates that only Sunday is considered a weekend.

Related functions

NETWORKDAYS WORKDAY.INTL DAYS