Count Number of Weekends/Weekdays/Specific Day of Week Between Two Dates in Excel
Tags: kutoolsexceltutorial, stepstocountthenumbe, kutools
Published: 2020-10-03 10:55:40

---
title: Count Number of Weekends/Weekdays/Specific Day of Week Between Two Dates in Excel
published: true
date: 2020-10-02 12:17:38 UTC
tags: KutoolsExcelTutorial,StepstoCounttheNumbe,Kutools
canonical_url: https://geekexcel.com/count-number-of-weekends-weekdays-specific-day-of-week-between-two-dates-in-excel/
---

## Count Number of Weekends/Weekdays/Specific Day of Week Between Two Dates in Excel:

In this article, we are going to see how to **Count the Number of Weekends/Weekdays/Specific Day of Week Between Two Dates in Excel Office 365** using **Kutools. ** Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Count the Number of Weekends Between Two Dates:

To count the number of weekends between two dates in the Excel spreadsheet, do as follows.

- Let’s consider the below sample dates to find the number of weekends between them.

![Sample dates](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Sample-dates.png)<figcaption id="caption-attachment-14978">Sample dates</figcaption>

- You need to **select** a **blank cell** to get the result.
- On the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper**  option from the menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- You need to **select** the **Number of non-working days between two dates** option under the **Choose a Formula** section.
- You can also **check** the **Filter** box and **enter the word between** into the text box to filter the formula quickly.
- Then, you need to **click** the **Browse** button given in the **Start date** option to **select the start date cell**.
- Again you need to **click** the **Browse** button given in the **End date** option to **select the end date cell**.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formula-Helper-dialog-box-1.png)<figcaption id="caption-attachment-14979">Formula Helper dialog box</figcaption>

- At last, hit the **OK** button to get the result.
- You can see the count of the number of weekends between two given dates in the selected cell.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-1.png)<figcaption id="caption-attachment-14980">Output</figcaption>

## Steps to Count the Number of All Weekdays Between Two Dates:

If you want to count the number of all weekdays between two dates, follow the below instructions.

- Let’s consider the below sample dates to find the number of weekdays ( **from Monday to Friday** ) between them.

![Example dates](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-2.png)<figcaption id="caption-attachment-14981">Example dates</figcaption>

- First, you need to **select a blank cell** to display the result.
- On the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper**  option from the menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- You need to **select** the **Number of working days between two dates** option under the **Choose a Formula** section.
- You can also **check** the **Filter** box and **enter the word between** into the text box to filter the formula quickly.
- Then, you need to **click** the **Browse** button given in the **Start date** option to **select the start date cell**.
- Again you need to **click** the **Browse** button given in the **End date** option to **select the end date cell**.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-2.png)<figcaption id="caption-attachment-14982">Formula Helper dialog box</figcaption>

- **Click** the **OK** button to get the result.
- You can see the count of the number of weekdays between two given dates in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-2.png)<figcaption id="caption-attachment-14983">Result</figcaption>

## Count the Number of Specific Weekday Between Two Dates:

To find the number of specific weekdays between two dates using Kutools, do as below steps.

- The following screenshot has shown the sample dates to find the number of specific weekdays between them.

![Sample input dates](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-1.png)<figcaption id="caption-attachment-14984">Sample input dates</figcaption>

- First, you need to **select a blank cell** to display the result.
- On the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper**  option from the menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- You need to **select** the **Count the number of specific weekday** option under the **Choose a Formula** section.
- You can also **check** the **Filter** box and **enter the word between** into the text box to filter the formula quickly.
- Then, you need to **click** the **Browse** button given in the **Start date** option to **select the start date cell**.
- Again you need to **click** the **Browse** button given in the **End date** option to **select the end date cell**.
- You have to **enter any number between 1 to 7** to specify the certain **weekday** in the **Weekday box.**
- 1 represents Sunday, 2-6 represents Monday to Friday, 7 represents Saturday.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-1.png)<figcaption id="caption-attachment-14985">Formula Helper dialog box</figcaption>

- **Click** the **OK** button to get the result.
- You can see the count of the number of specific weekdays between two given dates in the selected cell.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-1.png)<figcaption id="caption-attachment-14986">Output</figcaption>

### Note:

- You can **directly enter the start date and end date** into the text boxes in the **Formula Helper** dialog box.

## Wrap-Up:

In the above article, you can clearly understand the steps to **Count the Number of Weekends/Weekdays/Specific Day of Week Between Two Dates in Excel Office 365** using **Kutools. ** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Add Hours/Minutes/Seconds to a Datetime in Excel Office 365!!](https://geekexcel.com/add-hours-minutes-seconds-to-a-datetime-in-excel-office-365/)
- [Add/Subtract Years/Months/Days/Weeks to Date in Excel Office 365!!](https://geekexcel.com/add-subtract-years-months-days-weeks-to-date-in-excel-office-365/)