Returns the number of whole working days between two dates using custom weekend parameters.
構文
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])引数
start_date必須
The starting date of the period.
end_date必須
The ending date of the period.
weekend省略可能
A number or string indicating which days are weekends (default is 1, Saturday and Sunday).
holidays省略可能
An optional range of dates to be excluded from the working day count.
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.
=NETWORKDAYS.INTL("2023-01-01", "2023-01-31", 11)→26Calculates workdays in January 2023 where only Sunday is a weekend (represented by 11).
Select the cell
Click on the cell where you want to display the number of workdays.
Enter the formula
Type =NETWORKDAYS.INTL( followed by your start date, end date, and weekend code.
The value 11 indicates that only Sunday is considered a weekend.