 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2007Add day of week to data from external report (html)
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.  SignatureGerry 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 Signature--- 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 > 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 Wrote: > As long as you have that date and time in a cell > as an Excel datetime then it is simply a matter [quoted text clipped - 8 lines] > the > > column but would be acceptable to add a column for it. David M, Thanks for your help. I'll give it a try. Gerry St SignatureGerry St |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.