How do I Turning Dates into Quarters

[Guest]

I have a spreadsheet with dates in it (in format mm/dd/yyyy) that I would
like to translate into the appropriate fiscal quarter. For example...
Any date between 1/1/2005 and 3/31/2005 = Quarter1
Any date between 4/30/2005 and 6/30/2005 = Quarter2...

Any ideas?

 

[Ron de Bruin]

Hi Rob

You can use my Add-in to filter the quarter
http://www.rondebruin.nl/easyfilter.htm

You can filter in place or copy to other sheet/workbook

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks! One other complication...

Is there a formula that would work if the year-end is 9/30? For example:
10/1/04 - 12/31/04 = Quarter 1
1/1/05 - 3/31/05 = Quarter 2
4/30/05 - 6/30/05 = Quarter 3
7/1/05 - 9/30/05 = Quarter 4

 

[Jason Morin]

="Quarter"&ROUNDUP((MONTH(A1)+3)/3,0)-(MONTH(A1)>9)*4

HTH
Jason
Atlanta, GA