Как пользоваться функцией NETWORKDAYS.INTL в Excel
Русский | Английский |
---|---|
ЧИСТРАБДНИ.МЕЖД | NETWORKDAYS.INTL |
The NETWORKDAYS.INTL function in Excel allows users to calculate the number of workdays between two dates excluding weekends and specified holidays, with options to customize the weekly work schedule.
Syntax:
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
start_date
: The beginning date.end_date
: The ending date.weekend
: A code indicating the days of the week that are weekends (default is 1, representing Saturday and Sunday).holidays
: An optional range of dates that are to be considered as holidays.
Example Usage:
Consider a scenario where we have a table with project start and finish dates and need to calculate the number of working days between these dates, excluding weekends and holidays.
Start Date | End Date | Working Days |
---|---|---|
01.07.2021 | 15.07.2021 | =NETWORKDAYS.INTL(A2, B2) |
In this example, the NETWORKDAYS.INTL function will calculate the number of working days between July 1st and July 15th, 2021, and return the result.
Additional Features:
The NETWORKDAYS.INTL function also supports different weekend codes, making it flexible for different working schedules. For instance, you could specify only Sunday as the weekend (code 1) or Saturday and Sunday (code 3).
Additionally, you can specify a range of holidays as an extra parameter to exclude these dates from the workday count.
Больше информации: https://support.microsoft.com/ru-ru/office/функция-чистрабдни-межд-a9b26239-4f20-46a1-9ab8-4e925bfd5e28