Quarterly Analysis in Excel

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!
 
D

Don Guillett Excel MVP

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
 
Top