"L. Howard Kittle" wrote:

Hi Captn'

Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005


HTH
Regards,
Howard

"Captain" wrote in message
...
How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.

Thanks!
How do I get a cell to show the Week Number for specific dates?
Thanks again
Captain