Thanks!
--
Nicki Taylor


"CLR" wrote:

=IF(MONTH(A1)<4,"1st Quarter",IF(MONTH(A1)<7,"2nd
Quarter",IF(MONTH(A1)<10,"3rd Quarter",IF(MONTH(A1)<13,"4th Quarter",""))))

all on one line, watch out for email wordwrap...........

Vaya con Dios,
Chuck, CABGx3



"NTaylor" wrote:

How can I have my worksheet automatically update which Quarter it is?
--
Nicki Taylor