On Oct 12, 11:27*am, JSRothbart wrote:
I am trying to create a quarter to quarter analysis. I am using the
following equation to create the quarter off a give date.
="Q"&INT((MONTH(A1)/4)+1)&"-"&RIGHT(YEAR(A1),2)

Lets say for todays date that equation returns Q3 10. I want to make
the next cell generate the following quarter, Q4 10 but cannot figure
out the proper equation. Help!

="Quarter "&=INT((MONTH(a1)-1)/3)+1