Excel EXCEL 2003: Format cells for previous quarters

Joined
Nov 9, 2010
Messages
1
Reaction score
0
Using =ROUNDUP(MONTH(A1)/3,0) & "Q" & RIGHT(YEAR(A1),2) I can determine the current quarter and year. Is there a way to display the previous 11 quarters?

For example, cell A1 is the current date. In cell N2 I am entering the formula above - how would I display the previous quarters in cells C2 - M2 based on the date entered in A1?

What I would like to end up with is a way to always show the quarterly values based on the current date:
08Q1 08Q2 08Q3 08Q4 09Q1 09Q2 09Q3 09Q4 10Q1 10Q2 10Q3 10Q4

Thanks in advance!
 
Last edited:

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

Top