CLR wrote:
Another way..............

Down column I, put
1/1/2002
3/31/2002
6/30/2002
9/30/2002

Down column J, put
1st
2nd
3rd
4th

In A2 put this formula and copy down..........
=VLOOKUP(C2,$I$1:$J$4,2,TRUE)

Vaya con Dios,
Chuck, CABGx3





"gls858" wrote in message
...

I seem to always have trouble when dealing with dates in Excel.
Is it possible to have a formula the would look at the date field
and fill in the quarter in col 1? Dates 01/01/02 - 03/31/02 = Qtr1
and so forth.

Sample data:
A B C
Qtr Invoice Date
325938-0 1/2/2002
326529-0 1/4/2002
326910-1 1/7/2002
326942-0 1/7/2002
C 324534-0 1/9/2002
328088-0 1/10/2002

gls858



Thank you all for the suggestions. I'll give them a try tomorrow.

gls858