Another way


for months

LEFT(TEXT(A1,"mmm"))

for days


LEFT(TEXT(A1,"ddd"))



--
Regards,

Peo Sjoblom


"Del Cotter" wrote in message
...
Is there a way to format an Excel date such that

- the day of the week appears as a single letter? SMTWTFS

or

- the month appears as a single letter? JFMAMJJASOND

without resorting to text expressions?

--
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.