Hi,
Based on a date entered into the curent Month Cell:
Current Month 01-Sep-06
I want to be able to compute what the historical q-End dates for the last 4 quarters would be: E.g:
Q305 Q405 Q106 Q206
01-Sep-05 01-Dec-05 01-Mar-06 01-Jun-06
Can anyone offer any guidance on how to do this: So for example when the date is 01-Sep-06 I want the Quarter ends to stay as they are above but when I get to 01-Oct-06 I want the quarter ends to look like this:
Q405 Q106 Q206 Q306
01-Dec-05 01-Mar-06 01-Jun-06 01-Sep-06
The red cells are where i am hoping to puit my formulas based on the "Current Month" cell. (I already have formulas to work out the green bits but they are based on the red bits!)
Thanks in advance for any help!
Mandy
Based on a date entered into the curent Month Cell:
Current Month 01-Sep-06
I want to be able to compute what the historical q-End dates for the last 4 quarters would be: E.g:
Q305 Q405 Q106 Q206
01-Sep-05 01-Dec-05 01-Mar-06 01-Jun-06
Can anyone offer any guidance on how to do this: So for example when the date is 01-Sep-06 I want the Quarter ends to stay as they are above but when I get to 01-Oct-06 I want the quarter ends to look like this:
Q405 Q106 Q206 Q306
01-Dec-05 01-Mar-06 01-Jun-06 01-Sep-06
The red cells are where i am hoping to puit my formulas based on the "Current Month" cell. (I already have formulas to work out the green bits but they are based on the red bits!)
Thanks in advance for any help!
Mandy