Putting the Quarter on the page
If it's only calendar quarters, this is shorter
=INT((MONTH(TODAY())+2)/3)&"th Quarter"
--
Regards,
Peo Sjoblom
"CLR" wrote in message
...
=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
|