Use the NETWORKDAYS function in Google Sheets to calculate the number of whole workdays between specified start and end dates. This function automatically removes weekend days (Saturday and Sunday) from the total. Specific days, such as legal holidays, can also be omitted.
Google Spreadsheets Tips: How to Calculate Days Between Dates?
The syntax for the NETWORKDAYS function is NETWORKDAYS(start_date, end_date, [holidays]).
For both date arguments, use date values, serial numbers, or the cell reference to the location of this data in the worksheet.
Holiday dates can be date values entered directly into the formula, or cell references to the location of the data in the worksheet.
