5 Rolling Quarters

[ellis27]

Hi All,

I'm trying to get the rolling quarters based on the Current quarter input. Can anyone please show me how to get the last 5 rolling quarters.

20083 is my Current Quarter and taking this as input, I should generate the below values :

20083
20082
20081
20074
20073

Please help.
thanks,
Ellis

[martindwilson]

=if(right(a1,1)="1",(left(a1,3)&right(a1,2)-7),(left(a1,3)&right(a1,2)-1))