Count Of Quarter 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.
You might be interested also in date duration calculator.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
