NETWORKDAYS.INTL Function Explained
The NETWORKDAYS.INTL Function in Microsoft Excel calculates the number of working days between two dates, excluding weekends and holidays. It takes two arguments: start_date and end_date, and an optional third argument, holidays, which is a range of dates to exclude from the calculation.
NETWORKDAYS.INTL Function Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
- start_date: The start date of the period to consider for counting workdays.
- end_date: The end date of the period to consider for counting workdays.
- weekend: (Optional) A number or string that specifies which days of the week are considered weekends. The default value is “1101001” (Saturday and Sunday).
- holidays: (Optional) A range of cells that contain dates to exclude from the working calendar, such as legal holidays and other days that the business is closed.