The NETWORKDAYS.INTL function in Google Sheets is a powerful tool that calculates the number of net working days between two dates, allowing users to define which days constitute the weekend and to account for holiday dates. This specificity makes it highly useful for businesses and individuals who need to manage timelines and schedules more effectively, especially in terms of project management and labor calculations.

Syntax

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

• start_date: The beginning date of the period to examine.
• end_date: The ending date of the period to be analyzed.
• weekend: An optional parameter that specifies which days of the week are treated as weekends (non-working days).
• holidays: An optional range of one or more dates to exclude from the working days count.

Example #1

NETWORKDAYS.INTL("2023-10-01", "2023-10-15", 1)

This function calculates the number of working days between October 1, 2023, and October 15, 2023, excluding the default weekend (Saturday and Sunday). The result would be 10 working days.

Example #2

NETWORKDAYS.INTL("2023-10-01", "2023-10-15", "1111100")

Here, the function counts working days between October 1 and October 15, 2023, treating Friday and Saturday as weekends (1 represents a non-working day). The output would give the count of working days excluding these two days, resulting in 9 working days.

Example #3

NETWORKDAYS.INTL("2023-10-01", "2023-10-15", 1, {"2023-10-08", "2023-10-09"})

This example calculates the working days between October 1 and October 15 while excluding the holiday dates of October 8 and 9, which would yield a total of 8 working days.

Error handling

• VALUE! – This error occurs if any of the arguments are of incorrect types, such as if date parameters are mistakenly formatted as text.
• NUM! – This error may arise if the start_date is later than end_date, indicating invalid date range.
• REF! – If the holidays parameter refers to a non-existent range or cell, this error will be displayed.

Conclusion

The NETWORKDAYS.INTL function is an invaluable asset for users who require precise calculations of working days while accommodating customized weekends and holidays. By utilizing this function, users can streamline their scheduling efforts, improve project management, and ensure accurate resource allocation. Its flexible parameters allow it to adapt to various work environments, making it a versatile tool in any spreadsheet.