Conditional formula to assign any date to specific Quarter

[VBNewb]

So Im trying to figure out how to get a forumla to check a cell for a date, then assign a quarter date.

Example if date is 7/2/11 then Quarter is QSep.

Here are the ranges:
QMar = 1/1 to 3/31
QJun = 4/1 to 6/30
QSep = 7/1 to 9/30
QDec = 10/1 to 12/31

[Bob Phillips]

Try

="Q"&CHOOSE(INT((MONTH(A2)+2)/3),"Mar","Jun","Sep","Dec")

[NBVC]

Try:

="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{"Mar","Jun","Sep","Dec"})

where A1 contains date.

[VBNewb]

Wow, did not think of that solution! Works great!