ExcelBanter - Quarterly Analysis in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Quarterly Analysis in Excel (https://www.excelbanter.com/excel-programming/443738-quarterly-analysis-excel.html)

JSRothbart

Quarterly Analysis in Excel

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!

Don Guillett Excel MVP

Quarterly Analysis in Excel

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

All times are GMT +1. The time now is 03:59 PM.