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.
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.
You might be interested also in date duration calculator.