Help with a day of week formula

[Dave Potter]

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]

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]

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]

Thanks Harlan. Worked like a charm!
Dave

=TEXT(SomeDate,"dddd")

 

[Myrna Larson]

Of course, July 14,2003 is a Sunday.

It is? Not in Wisconsin <g>.

 

[Ron Rosenfeld]

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]

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