Excel Formulas to Count Dates in Current Month ~ Simple Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-05-10 03:06:27

---
title: Excel Formulas to Count Dates in Current Month ~ Simple Tutorial!!
published: true
date: 2021-05-07 13:27:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-dates-in-current-month-simple-tutorial/
---

Assume that you have a list of dates, and you need to know how many dates are there in the current month, next month, or the previous month. In this chapter, we will see the formula to calculate them quickly. Let’s see how to **count dates in the current month** in Excel. 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)

[![Count dates in current month](https://geekexcel.com/wp-content/uploads/2021/05/Count-dates-in-current-month.png)](https://geekexcel.com/excel-formulas-to-count-dates-in-current-month-simple-tutorial/count-dates-in-current-month/#main)<figcaption id="caption-attachment-37164">Count dates in the current month</figcaption>

## General Formula:

- Use the below formula to count dates in the current month.

**=[COUNTIFS](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)(rng,”>=”&[EOMONTH](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/)([TODAY](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)(),-1)+1,rng,”<“&EOMONTH(TODAY(),0)+1)**

## Syntax Explanations:

-   **EOMONTH** – The **[EOMONTH Function](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/)** returns the last day of the month after adding/subtracting a specified number of months to a date.
- **COUNTIFS**  – In Excel, this function will help to count the number of cells that meet multiple conditions or criteria.
- **TODAY** – This function is useful to know the current date on your workbook. Read more on the **[TODAY function](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)**.
- **Plus operator (+)** – This symbol is used to add the values.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Dates** – It represents the input date from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- First, we will enter the input dates in **Column B**.
- Now we are going to count them based on the specified month given in **Column D**.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-9.png)<figcaption id="caption-attachment-37162">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-21.png)<figcaption id="caption-attachment-37165">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-21.png)<figcaption id="caption-attachment-37163">Result</figcaption>

## Conclusion:

Hope you like this article on how to **count dates in the current month in Excel**. Let me know if you have any  **doubts** regarding this article or any other article on this site.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Calculate the Years Between Dates ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-years-between-dates/)**
- **[Excel Formulas to Assign Points Based on Late Time ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-assign-points-based-on-late-time/)**
- **[How to Validate Only Numbers in Cell in Excel Office 365?](https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/)**