sorting dates into calendar quarters

[sam88]

I have a situation where I need to sort dates into quarters. The data are more than 10,000 lines.
Example:
1/1/06, 2/1/06, 3/3/06, 4/6/06,5/7/06,6/9/06,7/9/06,1/1/05,1/1/04 ...etc.... I need to separate them into 1/1/06 = QTR 1 2006, 2/1/06 = QTR 1, 2006, 3/3/06= QTR 1, 2006, 4/6/06 = QTR 2 2006, 5/7/06 = QTR 2 2006, 7/9/06 = QTR 3, 2006, 1/1/05 = QTR 1, 2005, 1/1/04 = QTR 1 2004 etc...

Is there a way to do this ? Thanks...

 

[barry houdini]

If you have a date in A1 you can generate "QTR 1 2006" or similar with this formula

="QTR "&INT((MONTH(A1)+2)/3)&" "&YEAR(A1)

 

[sam88]

thanks Jon & Barry. I really appreciate your help.

 

[sam88]

Why Jon's answer diapperar ?

 

[sam88]

Barry,
I tried but it gave me "#VALUE!" error message. Any help will be appreciated.

 

[sam88]

Barry, my mistake, it works. Thanks...