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.
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.