Originally Posted by David McRitchie

As long as you have that date and time in a cell
as an Excel datetime then it is simply a matter
of formatting in Excel, Format (menu), cells, custom
ddd mm/dd/yyyy hh:mm

--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gerry St" wrote in message ...

I have a spreadsheet which lists a date and time as 1/02/2007 8:31:36
AM. I would like to be able to add the day of the week for the date in
column A. It would be preferred to have the day appear directly in the
column but would be acceptable to add a column for it.




--
Gerry St