On Mon, 11 Jun 2007, in microsoft.public.excel.worksheet.functions,
Peo Sjoblom said:

Another way
for days

LEFT(TEXT(A1,"ddd"))

Thanks guys. I can do it as text, but I had hoped for a formatting
option that would let me retain the date nature of the cell contents.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.