Table of Contents
In Google Sheets, you can count the number of workdays between two dates by using the NETWORKDAYS function. This function takes two dates as inputs and returns the number of days between them, excluding weekends and holidays. You can also specify a range of holidays that should be excluded in the calculation. This makes it an ideal tool for calculating the number of workdays between two dates.
You can use the NETWORKDAYS function in Google Sheets to count the number of workdays between two dates.
This function uses the following basic syntax:
NETWORKDAYS(start_date, end_date, [holidays])
where:
- start_date: The start date
- end_date: The end date
- holidays: A list of holiday dates to skip when counting (optional)
The following examples show how to use this formula in practice.
Example 1: Count Workdays Between Two Dates
Suppose we want to calculate the number of workdays between 1/1/2022 and 1/10/2022.
We can use the following formula to do so:
=NETWORKDAYS(A2, B2)
The following screenshot shows how to use this formula in practice:
There are 6 workdays between 1/1/2022 and 1/10/2022.
We can confirm this by counting the number of workdays between the two dates on a calendar:
There are indeed 6 workdays between the two dates.
Example 2: Count Workdays Between Two Dates (Specify Holidays)
- Easter (4/17/2022)
- Halloween (10/31/2022)
- Thanksgiving (11/24/2022)
- Christmas (12/25/2022)
We can use the following formula to do so:
=NETWORKDAYS(A2, B2, A8:A11)
The following screenshot shows how to use this formula in practice:
There are 214 workdays between 3/1/2022 and 12/27/2022, excluding the list of holidays that we specified.
Note: You can find the complete documentation for the NETWORKDAYS function in Google Sheets .