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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get the sum of the value by filtering 3 columns 2
Calendar Logic: Recurring Dates 3
Quarterly date format issues 5
Crate Table Query - Closest to the 15th day..... 0
How do I force a pivot column if there is no data? 5
Quarterly Formula 1
Multiple If statements, Calculating quarterly % holding costs 0
Calculating quarterly values from YTD values 5

Top