Help with a day of week formula

Dave Potter · Jul 14, 2003

I'd like to look up the date (7/14/03) in one cell and return the day
of the week (Monday) as text in another cell. TIA
Dave

Harlan Grove · Jul 14, 2003

I'd like to look up the date (7/14/03) in one cell and return the day
of the week (Monday) as text in another cell. TIA

=TEXT(SomeDate,"dddd")

Ron Rosenfeld · Jul 14, 2003

I'd like to look up the date (7/14/03) in one cell and return the day
of the week (Monday) as text in another cell. TIA
Dave

=TEXT(TODAY(),"dddd")

will return the day of the week as text. Of course, July 14,2003 is a Sunday.

--ron

Dave Potter · Jul 14, 2003

Thanks Harlan. Worked like a charm!
Dave

=TEXT(SomeDate,"dddd")

Myrna Larson · Jul 14, 2003

Of course, July 14,2003 is a Sunday.

It is? Not in Wisconsin <g>.

Ron Rosenfeld · Jul 14, 2003

It is? Not in Wisconsin <g>.

Well, here in Downeast Maine everything's screwed up, including the inhabitants
and their calendars <g>!

--ron

Ron Rosenfeld · Jul 14, 2003

Or just use =A1 and custom format the cell to dddd. And
Sunday is the 13th, not the 14th on this planet.

Some have said that Downeast Maine is not really part of this planet. Others
would be happier if it were not :-)

--ron