How to Count the Number of Workdays Between Dates in Google Sheets

To count the number of workdays between dates in Google Sheets, you can use the NETWORKDAYS function. This function calculates the number of working days between two dates, excluding weekends and optionally holidays. Here's how you can use the NETWORKDAYS function:

1. Open your Google Sheets document or create a new one.
2. Click on a cell where you want to display the number of workdays between two dates.
3. Type the formula =NETWORKDAYS(start_date, end_date, [holidays]), where:
   • start_date is the cell containing the starting date.
   • end_date is the cell containing the ending date.
   • [holidays] is an optional range of cells containing holiday dates. If you don't want to exclude any holidays, you can leave this part out of the formula.
4. Press Enter to complete the formula and display the number of workdays between the specified dates.

Example

In this example, we have two dates in cells A1 and B1, and we want to calculate the number of workdays between these dates, excluding weekends and holidays.

1. Start by listing the holiday dates in a separate column or row, for example, in cells E1:E3.
2. Click on cell C1 to display the result of the formula.
3. Type the formula =NETWORKDAYS(A1, B1, E1:E3) and press Enter.This will calculate the number of workdays between the dates in cells A1 and B1, excluding weekends and the holidays listed in cells E1 to E3.

Google Sheets will now display the number of workdays between the two specified dates, excluding weekends and holidays. If the dates or holidays change, the formula will automatically update to display the correct number of workdays.