NETWORKDAYS Function in Google Sheets

Calculate the number of working days between two dates using the NETWORKDAYS function.

NETWORKDAYS Function

The NETWORKDAYS function in Google Sheets calculates the number of working days between two dates.

Syntax

NETWORKDAYS(start_date, end_date, [holidays])
  • start_date: The start date of the period.
  • end_date: The end date of the period.
  • holidays: (Optional) A range of dates to consider as holidays.

Examples

  1. Working Days Between Two Dates

Calculate the working days between 2024-01-01 and 2024-01-31:

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

Calculate the working days excluding specific holidays:

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

Notes

  • Considers Saturday and Sunday as weekends by default.
  • Useful for project planning and resource management.