Excel Formulas to Count the Cells Between Two Dates!!
Tags: excelformula, excelformulas
Published: 2020-10-27 09:25:11

---
title: Excel Formulas to Count the Cells Between Two Dates!!
published: true
date: 2020-10-23 09:02:24 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-the-cells-between-two-dates/
---

In this tutorial, we will show how to use the **Formulas to Count the cells between two dates in Excel** with its basic syntax and explanations. Let’s get started!! 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 Cells between two dates](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Count-Cells-between-two-dates-2.png)<figcaption id="caption-attachment-16286">Count Cells between two dates</figcaption>

## Jump To:

- [**General Formula**](#1)
- [**Explanation**](#2)
- [**Example**](#3)
- [**Verdict**](#4)

## General Formula:

- To count the cells between two dates in Excel, use the below formula.

**=COUNTIFS(range,”>=”&date1,range,”<=”&date2)**

## Explanation:

- **COUNTIFS** -The COUNTIFS function helps to count cells that match multiple criteria.
- **Ranges** – It contains the **input ranges.**
- **Date** -It specifies the **Start date** and **End date** of the year. It also creates a date with year, month, and date.
- The syntax for the date function is  **=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([year](https://geekexcel.com/how-to-use-year-function-in-excel-365/), [month](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/), [day](https://geekexcel.com/how-to-use-day-function-in-excel-365/))**
- **Operators (“>=” ,”<=”)** – The operators are used to check the condition between two dates.
- **Concatenation (&)** – It can join the operators to each date. Read more on **[Concatenation.](https://geekexcel.com/how-to-use-concat-function-in-microsoft-excel-365/)** 
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below image, you can see the input Names and Birthday dates in **Column**  **A** & **Column**  **B**.
- Then, enter the given formula in the formula bar section.
- After applying the formula you can get the result in **Cell E2.**

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

- From the above example, you can understand how to use the formula to count the cells between two dates.

## Verdict:

In this article, you can learn the **formulas to count the cells between two dates in Excel Office 365** with a suitable example. If you have any **queries,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **

### Read Also:

- **[Formulas for Counting the Times a Word Appears in a Cell in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16248&action=edit)**
- **[Formulas to Lookup a Value and Return a Different Cell From the Table!!](https://geekexcel.com/wp-admin/post.php?post=16146&action=edit)**
- **[Excel Formula to Count the Occurrences of a Character in a String!!](https://geekexcel.com/wp-admin/post.php?post=16199&action=edit)**