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.
end_date are included in the count of days.
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.
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.
#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.
Example 1 – Simple Count of Workdays With No Extra Holidays
Let’s start with a straightforward example.
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.
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.
As shown in cell
C2, we specified
11/24/22 as a
holiday, therefore removing it from the count of workdays.
Example 3 – Using Days and Times
Be careful when using dates that include time values.
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
Go to this spreadsheet for the examples of the NETWORKDAYS function shown above that you can study and use anywhere you want.
Consider using the IMPORTXML function to obtain a list of your local holidays from the web.