=text(today(),"dddd")

returns a string like Monday

--
Regards,
Tom Ogilvy

"chris" wrote in message
...
There is a WeekDayName function, but its a VBA function not a worksheet
Function. I'm not sure how to call it in a worksheet , maybe someone else
does.

x = WeekDayName(Weekday(MyDate))