How can I have my worksheet automatically update which Quarter it is?
C CLR Dec 14, 2005 #2 =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
=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
P Peo Sjoblom Dec 14, 2005 #3 If it's only calendar quarters, this is shorter =INT((MONTH(TODAY())+2)/3)&"th Quarter"
N NTaylor Dec 14, 2005 #4 Thanks! -- Nicki Taylor CLR said: =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 Click to expand...
Thanks! -- Nicki Taylor CLR said: =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 Click to expand...
