=LEFT(TEXT(H12,"ddd"))

--
Regards

Roger Govier


"Robbyn" wrote in message
...
Hi all,

I use =TEXT(H12,"dddd") to calculate the day of week for a date. Is there
any way I can have the first letter of the day show, instead of the whole
word?

Monday becomes M; Tuesday becomes T, etc.