Add day of week to data from external report (html)

[Gerry St]

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.

 

[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

 

[Gerry St]

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

David M,
Thanks for your help. I'll give it a try.
Gerry St