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
|