software

I need a formula that will display the day (i.e. Sunday, Monday, etc..)
based on a date in another cell (i.e. B2). Thanks in advance--
Weasel
------------------------------------------------------------------------
Weasel's Profile: www.excelforum.com/member.php...oamp;userid=27206
View this thread: www.excelforum.com/showthread...hreadid=511847=TEXT(B2,quot;ddddquot;)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Weaselquot; gt; wrote in
message ...
gt;
gt; I need a formula that will display the day (i.e. Sunday, Monday, etc..)
gt; based on a date in another cell (i.e. B2). Thanks in advance
gt;
gt;
gt; --
gt; Weasel
gt; ------------------------------------------------------------------------
gt; Weasel's Profile:
www.excelforum.com/member.php...oamp;userid=27206
gt; View this thread: www.excelforum.com/showthread...hreadid=511847
gt;
Two other methods...pick your preference.

Use custom formating (Format gt; Cellsgt; Custom enter dddd in the custom
window

=CHOOSE(WEEKDAY(A1),quot;Sunquot;,quot;Monquot;,quot;Tuequot;,quot;Wedquot;,quot;Thuquot;, quot;Friquot;,quot;Satquot;)

- John