Hi!

Another way:

=TEXT(A1,"dddd")

Biff

"andrewm" wrote in
message ...

Hi

I would like to convert a date to a day of the week

ie column 1 column 2
5/7/05 Tuesday
6/7/05 Wednesday
etc etc

I know the formula for date - what is it to relate day of the week to
the date

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=384433