Workday Calculation with NETWORKDAYS.INTL in Google Sheets
Channel: Biddrup 
Date: 10/06/2023

Say Goodbye to Manual Counting: Automate Workday Calculations with NETWORKDAYS.INTL in Google Sheets

When it comes to managing projects or tracking deadlines, calculating the number of working days between two dates is a common requirement. Whether you want to exclude weekends or specific holidays from your calculations, Google Sheets has got you covered with the NETWORKDAYS.INTL function. In this blog post, we'll explore how to use this powerful function to effortlessly calculate net working days based on your specific needs.

Understanding the NETWORKDAYS.INTL Function:
The NETWORKDAYS.INTL function in Google Sheets is designed to determine the number of working days between two provided dates while excluding specified weekend days and holidays. Its flexibility allows you to customize the definition of weekends and incorporate any holidays that may affect your calculations.

Syntax Breakdown:
The NETWORKDAYS.INTL function follows a specific syntax:
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

1. start_date: This parameter represents the starting date of the period for which you want to calculate the net working days.
2. end_date: This parameter signifies the ending date of the period for the calculation.
3. [weekend]: An optional parameter that defines which days of the week are considered weekends. You have two methods to specify weekends:

   - String Method: Use seven 0's and 1's, where the first number represents Monday and the last number represents Sunday. 0 denotes a work day, while 1 denotes a weekend day. For example, "0000011" would mean Saturday and Sunday are weekends.

   - Number Method: Instead of the string method, you can use a single number to define weekends. The numbers 1 to 7 correspond to different weekend patterns, such as 1 for Saturday/Sunday, 2 for Sunday/Monday, and so on.

4. [holidays]: An optional parameter that allows you to specify holidays. It can be a range or array constant containing the dates to be considered as holidays.

Examples of NETWORKDAYS.INTL Usage:
Let's dive into a few examples to see the NETWORKDAYS.INTL function in action:

1. NETWORKDAYS.INTL(DATE(1969, 7, 16), DATE(1969, 7, 24), 1, A1:A10)
   - This example calculates the net working days between July 16, 1969, and July 24, 1969, considering Saturday and Sunday as weekends. It also excludes any dates specified in the range A1:A10 as holidays.

2. NETWORKDAYS.INTL(DATE(1969, 7, 16), DATE(1969, 7, 24))
   - In this case, the function calculates the net working days between the same dates as the previous example. However, the default weekend (Saturday/Sunday) and holidays are considered since the [weekend] and [holidays] parameters are omitted.

3. NETWORKDAYS.INTL("12/04/1995", "12/22/1995", 3)
   - Here, the function calculates the net working days between December 4, 1995, and December 22, 1995, considering Tuesday and Thursday as weekends. It doesn't specify any holidays.

4. NETWORKDAYS.INTL("12/04/1995", "12/22/1995", "0000011")
   - This example calculates the net working days between the same dates as the previous example. However, it uses the string method to define weekends, considering Saturday and Sunday as non-working days.

1. Sarah, a project manager, needs to determine the number of working days for a client's project. She uses the NETWORKDAYS.INTL function to calculate the net working days between the project's start and end dates, excluding weekends and a specific set of holidays.

2. John, a human resources manager, wants to track the attendance of employees. He utilizes the NETWORKDAYS.INTL function to calculate the number of working days an employee was present, excluding weekends and public holidays.

3. Emily, a sales representative, is planning a business trip. She uses the NETWORKDAYS.INTL function to calculate the duration of her trip, considering only working days and excluding weekends and company holidays.

4. David, a teacher, wants to calculate the number of school days remaining in the academic year. He employs the NETWORKDAYS.INTL function to exclude weekends and public holidays from his calculations.

5. Lisa, a payroll administrator, needs to calculate the number of working days for employees' timesheets. She utilizes the NETWORKDAYS.INTL function to exclude weekends and bank holidays, ensuring accurate payroll calculations.

6. Mark, a logistics manager, wants to estimate the shipping time for an order. He employs the NETWORKDAYS.INTL function to calculate the expected delivery date, excluding weekends and any holidays that might affect the transit time.

7. Jessica, an event planner, is organizing a conference and needs to determine the duration of the event. She uses the NETWORKDAYS.INTL function to calculate the net working days between the conference's start and end dates, excluding weekends and public holidays.