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.

Leave a Comment