software

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

=IF(MONTH(A1)lt;4,quot;1st Quarterquot;,IF(MONTH(A1)lt;7,quot;2nd
Quarterquot;,IF(MONTH(A1)lt;10,quot;3rd Quarterquot;,IF(MONTH(A1)lt;13,quot;4th Quarterquot;,quot;quot;))))

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

Vaya con Dios,
Chuck, CABGx3
quot;NTaylorquot; wrote:

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

If it's only calendar quarters, this is shorter

=INT((MONTH(TODAY()) 2)/3)amp;quot;th Quarterquot;--

Regards,

Peo Sjoblomquot;CLRquot; gt; wrote in message
...
gt; =IF(MONTH(A1)lt;4,quot;1st Quarterquot;,IF(MONTH(A1)lt;7,quot;2nd
gt; Quarterquot;,IF(MONTH(A1)lt;10,quot;3rd Quarterquot;,IF(MONTH(A1)lt;13,quot;4th
Quarterquot;,quot;quot;))))
gt;
gt; all on one line, watch out for email wordwrap...........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;NTaylorquot; wrote:
gt;
gt; gt; How can I have my worksheet automatically update which Quarter it is?
gt; gt; --
gt; gt; Nicki Taylor
Thanks!
--
Nicki Taylorquot;CLRquot; wrote:

gt; =IF(MONTH(A1)lt;4,quot;1st Quarterquot;,IF(MONTH(A1)lt;7,quot;2nd
gt; Quarterquot;,IF(MONTH(A1)lt;10,quot;3rd Quarterquot;,IF(MONTH(A1)lt;13,quot;4th Quarterquot;,quot;quot;))))
gt;
gt; all on one line, watch out for email wordwrap...........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;NTaylorquot; wrote:
gt;
gt; gt; How can I have my worksheet automatically update which Quarter it is?
gt; gt; --
gt; gt; Nicki Taylor