פונקציית Google Sheets

NETWORKDAYS.INTL

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

יצירת נוסחה עם בינה מלאכותית אותה פונקציה ב-Excel

פונקציה זו פועלת ב-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.

ארגומנטים

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.

דוגמאות

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

תוצאה: 26

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

שאלות נפוצות

What does the weekend argument 11 mean?

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

פונקציות קשורות

NETWORKDAYS WORKDAY.INTL DAYS