How do I Turning Dates into Quarters
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?
|