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.

Syntax

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

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.

Thumbnail for the NETWORKDAYS function
YouTube Video Explaining NETWORKDAYS

Related functions

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.

Errors

#VALUE! – The inputs aren’t a valid date such as “The other day” or “Yester-yester-day”.

Examples

 ABCDEF
1
Start dateEnd dateHolidaysFormulaResultExplanation
2
3/4/164/1/16 =NETWORKDAYS(A2,B2)21Plain and simple, no holidays.
3
3/21/172/8/202512/25/2017=NETWORKDAYS(A3,B3,C3)2,058With one holiday.
4
8/23/18TOMORROW =NETWORKDAYS(A4,B4)#VALUE!
This error occurs when one or more of the values is not a number.
5
      
6
ResultFormula   Explanation
7
262
=NETWORKDAYS(DATE(2017,2,3),DATE(2018,2,5))
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.

Notes

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

Leave a Comment