Use the TEXT function:

=TEXT(date,"dddd")
where date is the date specifiedin standard date format like 1/18/2005.

good luck,

prashant
(not from Microsoft)

"quartz" wrote:

I know you can use WEEKDAY to return the NUMBER of the day. But how can I use
a formula on a spreadsheet (or a macro in VBA) to return the name of the day
spelled out? For example:

01-18-2005 should return "Thursday"

Thanks in advance.