Just FormatCellsNumberCustom tab. In The Type box, enter ddd or dddd
This leaves the date a date. Alternative in another cell:

=TEXT(A1,"ddd")

This makes the cell text.

"dannboy213" wrote
in message ...

Can someone help me figure out the formula for showing the name of day
based on a date.


--
dannboy213
------------------------------------------------------------------------
dannboy213's Profile:
http://www.excelforum.com/member.php...o&userid=31017
View this thread: http://www.excelforum.com/showthread...hreadid=506889