Count of quarters between dates

In this Excel tutorial lesson, you will learn how to calculate the count of quarters between two dates using the Excel application.

Quarters data analysis

Suppose you have two dates. You want to know how many quarters passed between these two dates. In cell B2 there is a later date. In cell A2 you typed an earlier date.

calculate how many quarters between dates

 

How many quarters between data formula

To calculate how many quarters are between these two days, just use the below formula.

=FLOOR(((YEAR(B2)*12+MONTH(B2))-(YEAR(A2)*12+MONTH(A2)))/3;1)

You can also calculate how many quarters there is between current day and some date (here in A2 cell).

=FLOOR(((YEAR(NOW())-YEAR(A2))*12+MONTH(NOW())-MONTH(A2))/3;1)

Results are rounded down.

You might also be interested in date duration calculator.