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