SheetFX
≡
<< Go back to all functions

NETWORKDAYS.INTL

The NETWORKDAYS.INTL function in Google Sheets returns the number of net working days between two provided days, excluding specified weekend days and holidays. This function is useful for calculating the number of working days in a given time period, taking into account custom weekend days and specific holidays.

Function Syntax and Parameters

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

Parameters:

  • start_date: The starting date of the time period.
  • end_date: The ending date of the time period.
  • weekend: [Optional] A number or string representing a weekend or array of weekend days.
  • holidays: [Optional] A range of cells or array of dates representing holidays.

Step-by-Step Tutorial

  1. Calculating network days excluding weekends only:

    • Example: =NETWORKDAYS.INTL(DATE(2022,1,1), DATE(2022,1,31), 1)
    • Result: 22

  2. Calculating network days excluding weekends and specific holidays:

    • Example: If A1:A3 has the holiday dates such as 2022/01/03, 2022/01/10, and 2022/01/17, then =NETWORKDAYS.INTL(DATE(2022,1,1), DATE(2022,1,31), 1, A1:A3) will return 19.

Use Cases and Scenarios

  1. Project Management: Calculate the number of working days required to complete a project.
  2. Leave and Attendance: Determine the number of leave days taken by an employee.
  3. Scheduling: Plan and schedule tasks or events based on the available working days.

Related Functions

  • NETWORKDAYS: Calculate the number of working days between two dates.
  • WORKDAY: Get the date that is a specified number of working days in the future or past.

Related Articles