How to Use NETWORKDAYS.INTL Function

NETWORKDAYS.INTL function returns the number of whole workdays between two dates with considering what and how many days are weekend days.

Formula:

= NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Explanations:

  • Start date is required, the first date.
  • End date is required, the second date.
  • Holidays is optional, the holidays between the two dates.
  • Weekend is optional, the days of the week that are weekend days.

Cautions:

  • If start_date is later than end_date, the return value will be negative, the number of whole workdays in the past.
  • If start_date is out of range for the current date base value, NETWORKDAYS.INTL returns the #NUM! error value.

Download: NETWORKDAYS.INTL Function

Leave a Reply