On Sat, 23 Aug 2008, in microsoft.public.excel.worksheet.functions,
Shane Devenshire said:
=LEFT(TEXT(A1,"DDD"))

If you have a date in cell A1 then this formula will return a single
letter abbreviation of the day of the week. Of course the problem
here is that you must put the formula in another cell.

Shane, I'm familiar with text formulae. The original query was about not
using them.

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