=TEXT(B2,"dddd")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Weasel" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=511847