Putting the Quarter on the page
 

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

Putting the Quarter on the page
 

=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

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

Putting the Quarter on the page
 

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