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 Date at which to start the calculation

end_date Date at which to end the calculation

[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 length of time between two dates in years, months, and/or days.

MINUS – Subtract one value from another. Can be done with dates.

NETWORKDAYS.INTL – Calculate the number of work days between two dates. You can modify which days are weekends.

Errors

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

Examples

 Live examples in Sheets

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 Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>