Formula to Count Number of Weekends/Weekdays/Specific Day of Week!!
Tags: excelformula, excelformulas
Published: 2020-10-20 12:15:35

---
title: Formula to Count Number of Weekends/Weekdays/Specific Day of Week!!
published: true
date: 2020-10-20 08:42:47 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formula-to-count-number-of-weekends-weekdays-specific-day-of-week/
---

## Excel Formula to Count the Number of Weekends/ Weekdays/Specific Day of Week Between Two Dates:

This page will show the details on the **Formula to Count the number of Weekends/Weekdays/Specific Day of Week Between Two Dates in Excel Office 365**. 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)
## Formula Syntax:

- Here we will explain three types of formulas.

### Count the Number of Weekends:

- First, we will see the formula for counting the number of weekends between two dates.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)($C$3>=$C$2,[INT](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)(([WEEKDAY](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)($C$2-1)-$C$2+$C$3)/7)+INT((WEEKDAY($C$2-6)$C$3-1)/7)+INT((WEEKDAY($C$3-6)-$C$3+$C$2)/7))**

### Example 1:

- Let’s consider the below table to count the number of weekends between the two dates.
- First, you need to enter the inputs of the Start Date and End date.
- Then, you need to apply the given formula in the selected formula bar.
- After entering the formula, you can get the result in the selected cell as shown below.

### ![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-1.png)Count the Number of All Weekdays:

- The below formula is used for Counting the Number of All Weekdays Between two dates.

**=IF($C$3>=$C$2,INT($C$3-$C$2)+1-(INT((WEEKDAY($C$2-1)-$C$2+$C$3)/7)+INT((WEEKDAY($C$2-7)-$C$2+$C$3)/7)),INT($C$2-$C$3)+1-(INT((WEEKDAY($C$3-1)-$C$3+$C$2)/7)+INT((WEEKDAY($C$3-7)-$C$3+$C$2)/7)))**

### Example 2:

- In the below screenshot, you can know the steps for counting the number of all weekdays using the formula.
- You need to enter the inputs of Start Date and End Date.
- After that, enter the given formula in the selected area.
- Finally, it will display the results in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-2.png)

### Formulas to count the Number of  Specific Weekday Between Two Dates:

- To find the number of specific weekdays between two dates, use the below formula.

**=[ABS](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)(INT(WEEKDAY($C$2-5)-$C$2+$C$3)/7))**

### Example 3:

- Let’s consider the below screenshot to count the number of specific weekdays between two dates.
- You need to enter the input dates as shown in the image.
- After that, enter the given formula in the selected field.
- Finally, you will get the results as shown below.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-1.png)

## Explanations for Syntax:

- **IF** – The Excel[**IF function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/) is used to returns one value for a TRUE result, and another one value for a FALSE result.
- **INT ** -The main purpose of [**INT Function**](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/) is to round a given integer number down to the nearest integer.
- **WEEKDAY ** – It will return a number ranging from 1 to 7 which represents a day of the week for a given date. Read more on [**WEEKDAY Function**](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/).
- **ABS** – This function will return the absolute value of a number. For more details on [**ABS Function**](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/).

## Verdict:

From this article, you can get the clarification on the **formulas for counting the number of weekdays/weekends/specific days of a week between two date-times** in the Excel Office 365. If you have any suggestions, drop it in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**