SheetFX
≡
<< Go back to all functions

NETWORKDAYS

The NETWORKDAYS function in Google Sheets is a powerful tool to calculate the number of net working days between two provided days. Whether you're calculating project timelines, tracking employee attendance, or managing vacation schedules, the NETWORKDAYS function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: NETWORKDAYS(start_date, end_date, [holidays])

Parameters:

  • start_date: The start date of the period.
  • end_date: The end date of the period.
  • holidays: [Optional] A range or list of dates representing holidays.

Step-by-Step Tutorial

  1. Using NETWORKDAYS with specific dates and holidays:
    • Example: =NETWORKDAYS(DATE(2022, 1, 1), DATE(2022, 12, 31), H2:H10)
    • Result: Returns the number of net working days between January 1, 2022, and December 31, 2022, excluding the dates in the range H2:H10.

Use Cases and Scenarios

  1. Project Planning: Calculate the duration of a project in working days.
  2. Leave Management: Determine the number of days an employee is absent during a specific period.
  3. Business Operations: Calculate the turnaround time for customer service requests.

Related Functions

  • WORKDAY: Returns a date that is a specified number of working days before or after a provided date.
  • NETWORKDAYS.INTL: Calculates the number of working days between two dates using parameters to specify different weekend days and custom holidays.

Related Articles