Google Sheets NETWORKDAYS.INTL Function: Syntax, Examples & Tips

start_date:
The starting date from which to begin counting the number of working days.

end_date:
The ending date up to which to count the number of working days.

weekend:
(Optional) A string or number that specifies which days of the week are considered weekends. If omitted, the default is Saturday and Sunday.

holidays:
(Optional) A range or array of dates that should be considered as non-working days in addition to weekends.

What is NETWORKDAYS.INTL?

The NETWORKDAYS.INTL function in Google Sheets is a useful tool for calculating the number of working days between two dates, while allowing for the specification of weekends and holidays. This function is particularly beneficial for project management, payroll calculations, and any scenario where understanding the number of business days is essential.

In simpler terms, NETWORKDAYS.INTL helps you determine how many weekdays fall between two dates, taking into account custom weekends and holidays.

A Practical Example

Imagine you are managing a project timeline and need to calculate the number of working days between the project start and end dates:

Project Timeline:

You want to find out how many working days are available for each task, considering that your weekends are Saturday and Sunday.

NETWORKDAYS.INTL Formula

To achieve this, you would use the NETWORKDAYS.INTL function as follows:

=NETWORKDAYS.INTL(B2, C2, 1)

In this formula:

• B2 is the cell containing the Start Date of the task.
• C2 is the cell containing the End Date of the task.
• 1 indicates that Saturday and Sunday are considered weekends.

Result of the Formula

When you apply the NETWORKDAYS.INTL formula to the Project Timeline, the output would look like this:

In this case, Task A has 7 working days available, while Task B has 8 working days.

Why Use NETWORKDAYS.INTL?

NETWORKDAYS.INTL is beneficial because it provides flexibility in defining weekends and allows for the inclusion of holidays. This makes it a powerful tool for accurately calculating working days in various business contexts. Additionally, it simplifies the process of managing project timelines and resource allocation.

Key Takeaways:

• NETWORKDAYS.INTL: A Google Sheets function that calculates the number of working days between two dates, considering custom weekends and holidays.
• Flexibility: Allows users to define which days are considered weekends, making it suitable for different work schedules.
• Holiday Consideration: You can also include a list of holidays to exclude from the working day count, enhancing accuracy.
• Common Use Cases: Ideal for project management, payroll calculations, and any scenario where tracking business days is necessary.

NETWORKDAYS.INTL is an essential function for anyone managing timelines and schedules in Google Sheets, providing a reliable way to enhance project planning and execution.

Happy spreadsheeting!