Quarterly Analysis in Excel

  • Thread starter Thread starter JSRothbart
  • Start date Start date
J

JSRothbart

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!
 
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!
Click to expand...

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