Count of quarter between dates

In this tutorial lesson you will teach yourself how to calculate the count of quarter between two dates using Excel application.

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

calculate how many quarters between dates

 

To calculate how many quarters are between these two days just use 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.