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

G

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.
 
D

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
 
Top