If cell A1 contains a true Excel date:

=TEXT(A1,"dddd") returns Wednesday

=TEXT(A1,"ddd") returns Wed

--
Biff
Microsoft Excel MVP


"DOUG ECKERT" wrote in message
...
I would like to know the formula to convert a date, such as *Wednesday,
1-Oct-08 to read "Wednesday", that is, plain old text which says
"Wednesday".
Please advise.

DOUG