# Learn How to Count Between Dates By Age Range In Microsoft Excel

Written by | 0 Comments | 559 Views

In this article, you will learn how to use the Microsoft Excel COUNT formula and its purpose in Microsoft Excel. You will also get to know how to count Between Dates By Age Range and see the generic formula.

Count Between Dates By Age Range Using Microsoft Excel Count Formula

The main purpose of the Microsoft Excel COUNT formula is to count the specific values between the provided entities. Here we will learn how to count values between two dates.  That implies, with the help of the COUNT formula you can able to count values between two dates that also fall into specific numeric ranges. It should be noted that you can use a formula based on the COUNTIFS function, with help from the LEFT, RIGHT, FIND, and LEN functions. So, with the help of the COUNT formula, you can able to count the specific values between the provided entities.

General Syntax of the COUNT Formula

=COUNTIFS(joined,">="&start,joined,"<="&end)

Explanation for the COUNT Formula So we know that Microsoft Excel COUNT formula you can able to count the specific values between the provided entities. In the example shown above we have used the COUNT formula to count rows in the data where the date joined falls between the start and end dates and the age also falls into the age ranges specified. So, with the help of the COUNT formula, you can able to count the specific values between the provided entities.