Returns the number of whole working days between two dates using custom weekend parameters.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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.
=NETWORKDAYS.INTL("2023-01-01", "2023-01-31", 11)결과: 26
Calculates workdays in January 2023 where only Sunday is a weekend (represented by 11).
The value 11 indicates that only Sunday is considered a weekend.