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.
start_dateDate at which to start the calculation
end_dateDate 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 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.
#VALUE!- The inputs are something that isn't a valid date such as "The other day" or "Yester-yester-day".
Live examples in Sheets
Go tothis spreadsheetfor the examples of the NETWORKDAYS function shown above that you can study and use anywhere you would like.