I think you'll get what you want by putting a formula in Col 2 of =Col 1,
Then custom format Col 2 to "Dddd"
Rgds,
ScottO

"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
|