Return day name from a date

[Guest]

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.

 

[Guest]

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)

 

[Tom Ogilvy]

Assume your date is in A1

=Test(A1,"dddd")

 

[Guest]

Thanks!

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)

 

[Tom Ogilvy]

Whoops, typo

=Test(A1,"dddd")
should be

=Text(A1,"dddd")

the cell could also be custom formatted using dddd