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.
Contents
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.
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.
TIMEDIF – Google Sheets Add-On
Calculate any duration in:
- Years
- Months
- Weeks
- Days
- Hours
- Minutes
- Seconds
- Milliseconds
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.
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 a 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 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 online.
Video Tutorial
