I have a date field that I want my formula(s) to look at and give me the
current quarter the date falls in, and also give me the previous 3 quarters
(showing a total of 4 quarters).

I want the formulas to adjust the quarters as I adjust the date.

So, if the date is 2/30/2009, I want my formulas to show the following:

2ND QTR 2008 3RD QTR 2008 4TH QTR 2008 2ND QTR 2009

And if I change the date to 6/30/2009, I want the formulas to show:

3RD QTR 2008 4TH QTR 2008 1ST QTR 2009 2ND QTR 2009

I want the quarters to show in this format: 2ND QTR 2009

I have tried this formula, but do not know how to adjust it to show the
previous 3 quarters:

=INT((MONTH($M$484)+2)/3)&"ND QTR "&YEAR($M$484)

Thanks - your help is always appreciated!