NETWORKDAYS Function – Google Sheets

The NETWORKDAYS function calculates the number of working days between two dates. The function excludes weekends (Saturday and Sunday) and can exclude holidays if you provide a list.

If you have weekends other than Saturday and Sunday, use the NETWORKDAYS.INTL function.

💡 The start_date and end_date are included in the count of days.

Function help text for the NETWORKDAYS function

Syntax

=NETWORKDAYS(start_date,end_date,[holiday(s)])

start_date The date at which to start the counting

end_date The date at which to end the counting

[holiday(s)] An optional list of holidays to exclude from the count of days.

Video Tutorial

Related Functions

DAYS – Calculate the number of days between two dates.

DATEDIF – Calculate the time between two dates in years, months, or days.

MINUS – Subtract one value from another. You can use dates with the MINUS function.

NETWORKDAYS.INTL – Calculate the number of workdays between two dates. You can modify which days are weekends.

Errors

#VALUE! – An input isn’t a valid date, such as “The other day” or “Yester-yester-day”. Learn how to work with dates in formulas.

Examples

Example 1 – Simple Count of Workdays With No Extra Holidays

Let’s start with a straightforward example.

The NETWORKDAYS function with two days for input and no other arguments
NETWORKDAYS With Start and End Dates

It’s easy to see how this function can save you time. In this example, NETWORKDAYS skips counting the eight weekend days between November 4, 2022 and November 29, 2022.

Calendar showing the workdays
Just a Start Date and an End Date

Looking at a calendar helps us understand what is happening. NETWORKDAYS counted every weekday between the start and end date and excluded the weekends.

Example 2 – Removing a Holiday from the Workday Count

Now let’s say that we are running a company in the United States where Thanksgiving is holiday. We don’t want to count Thanksgiving as a workday.

The NETWORKDAYS function that excludes a holiday
NETWORKDAYS with a Holiday

As shown in cell C2, we specified 11/24/22 as a holiday, therefore removing it from the count of workdays.

Calendar showing workdays less Thanksgiving
Excluding Thanksgiving

Example 3 – Using Days and Times

Be careful when using dates that include time values.

The NETWORKDAYS function ignoring times
Dates With Times

Google Sheets ignores time values from the inputs and, therefore may appear to return an incorrect result. Only seventeen workdays have passed if you consider the times but Sheets ignores the times and returns 18.

Live Examples

Go to this spreadsheet for the examples of the NETWORKDAYS function shown above that you can study and use anywhere you want.

Notes

Consider using the IMPORTXML function to obtain a list of your local holidays from the web.

Leave a Comment