# Excel Formulas to Count the Cells Between Two Dates!! Andrews Originally published at geekexcel.com on ・2 min read

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

## 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(year, month, day)
• 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.
• 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.   