Unless the Captain is English, then it would return TUE

<bg

--
Regards,

Peo Sjoblom

(No private emails please)


"L. Howard Kittle" wrote in message
...
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.