software

This is an easy one, but my brain just isn't working tonight!!

Here's the formula to show the day

=CHOOSE(WEEKDAY(quot;1 Jan
2006quot;),quot;Sunquot;,quot;Monquot;,quot;Tuequot;,quot;Wedquot;,quot;Thuquot;,quot;Friquot;,quot;Satquot;)

Is there a way to have a seperate cell w/ the year (let's say A2) and
instead of 2006 in the formula to have = A2, so when you change the
year, it automatically updates each day?

Thanks--
mrjeep
------------------------------------------------------------------------
mrjeep's Profile: www.excelforum.com/member.php...oamp;userid=34001
View this thread: www.excelforum.com/showthread...hreadid=538339=CHOOSE(WEEKDAY(DATE(A2,1,1)),quot;Sunquot;,quot;Monquot;,quot;Tuequot;,quot;W edquot;,quot;Thuquot;,quot;Friquot;,quot;Satquot;)

HTH
--
AP

quot;mrjeepquot; gt; a écrit dans
le message de news: ...
gt;
gt; This is an easy one, but my brain just isn't working tonight!!
gt;
gt; Here's the formula to show the day
gt;
gt; =CHOOSE(WEEKDAY(quot;1 Jan
gt; 2006quot;),quot;Sunquot;,quot;Monquot;,quot;Tuequot;,quot;Wedquot;,quot;Thuquot;,quot;Friquot;,quot;Satquot;)
gt;
gt; Is there a way to have a seperate cell w/ the year (let's say A2) and
gt; instead of 2006 in the formula to have = A2, so when you change the
gt; year, it automatically updates each day?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; mrjeep
gt; ------------------------------------------------------------------------
gt; mrjeep's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34001
gt; View this thread: www.excelforum.com/showthread...hreadid=538339
gt;
=CHOOSE(WEEKDAY(quot;1 Jan quot; amp;A2),quot;Sunquot;,quot;Monquot;,quot;Tuequot;,quot;Wedquot;,quot;Thuquot;,quot;Friquot;,quot;Satquot;)

but you could also do

=TEXT(quot;1 Janquot;amp;A2,quot;dddquot;)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;mrjeepquot; gt; wrote in
message ...
gt;
gt; This is an easy one, but my brain just isn't working tonight!!
gt;
gt; Here's the formula to show the day
gt;
gt; =CHOOSE(WEEKDAY(quot;1 Jan
gt; 2006quot;),quot;Sunquot;,quot;Monquot;,quot;Tuequot;,quot;Wedquot;,quot;Thuquot;,quot;Friquot;,quot;Satquot;)
gt;
gt; Is there a way to have a seperate cell w/ the year (let's say A2) and
gt; instead of 2006 in the formula to have = A2, so when you change the
gt; year, it automatically updates each day?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; mrjeep
gt; ------------------------------------------------------------------------
gt; mrjeep's Profile:
www.excelforum.com/member.php...oamp;userid=34001
gt; View this thread: www.excelforum.com/showthread...hreadid=538339
gt;