NETWORKDAYS.INTL Function in Google Sheets

Calculate the number of working days between two dates, with customizable weekends and holidays, using the NETWORKDAYS.INTL function.

NETWORKDAYS.INTL Function

The NETWORKDAYS.INTL function in Google Sheets calculates the number of working days between two dates with customizable weekends and holidays.

Syntax

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
  • start_date: The start date of the period.
  • end_date: The end date of the period.
  • weekend: (Optional) A number or string representing the weekend days.
  • holidays: (Optional) A range of dates to consider as holidays.

Examples

  1. Custom Weekend Days

Calculate the working days between 2024-01-01 and 2024-01-31 with Friday and Saturday as weekends:

=NETWORKDAYS.INTL("2024-01-01", "2024-01-31", 7)
  1. Working Days with Custom Holidays

Calculate the working days excluding specific holidays:

=NETWORKDAYS.INTL("2024-01-01", "2024-01-31", 1, A1:A3)

Notes

  • Weekend days can be specified using codes or custom strings.
  • Provides flexibility in calculating working days across different regions and industries.
  • NETWORKDAYS: Calculates working days with default weekends.