Count Working Days Between Dates In Google Sheets

NETWORKDAYS Function Syntax and Arguments

The syntax for the NETWORKDAYS function is NETWORKDAYS(start_date, end_date, [holidays]). The arguments are:

Start_date — the start date of the chosen period (required)End_date — the end date of the chosen period (required) Holidays — one or more additional dates that are excluded from the total number of working days (optional)

Use date values, serial numbers, or the cell reference to the location of this data in the worksheet for both date arguments. Holiday dates can be date values entered directly into the formula or the cell references to the location of the data in the worksheet.

The Math Behind the Function

Google Sheets processes its calculation in two steps. First, it assesses the straightforward count of working days between the two stipulated dates.  After that, it removes every date specified in the holidays argument, if the date occurred on a weekday. For example, if the time period included two holidays (e.g., Memorial Day and Independence Day, in the United States), and those days both occur on a weekday, then the original count between dates is reduced by two, and the answer is displayed in the spreadsheet.