gls858 a écrit :
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
Hi gls858,
In that case, consider the month and not the date.
Quarter has a relation with 3 months.
Why not =int((month(C1)+2)/3) ?
HTH
FxM
|