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.
start_date The date at which to start the calculation
end_date The date at which to end the calculation
[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 length of 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! – The inputs aren’t a valid date such as “The other day” or “Yester-yester-day”.
|Start date||End date||Holidays||Formula||Result||Explanation|
|3/4/16||4/1/16||21||Plain and simple, no holidays.|
|3/21/17||2/8/2025||12/25/2017||2,058||With one holiday.|
This error occurs when one or more of the values is not a number.
||Using the DATE function.|
Go to this spreadsheet for the examples of the NETWORKDAYS function shown above that you can study and use anywhere you would like.
Consider using the IMPORTXML function to obtain a list of your local holidays from the web.