andrewm,

If your date is in A1 put this into B1 and copy down as
necessary.

'=TEXT(A1,"dddd")

Dave

andrewm Wrote:
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


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