LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Taylor
 
Posts: n/a
Default Date to a day (Monday, Tue, etc?)

I would like to convert numeric dates to letter days of the week. For example,
9/13/2005 would convert to "Tuesday" or "Tue". 10/20/2005 would convert to
"Thursday" or "Thu". 11/20/2005 would convert to Sunday" or "Sun".

Is there a way to do this for all dates in the current year and future years?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
adding day (sunday, Monday) to date RickyDee Excel Worksheet Functions 4 September 10th 05 07:14 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
How do I get a footnote to give the date Monday, 4 July 2005 Victor Excel Discussion (Misc queries) 3 July 4th 05 10:09 PM
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? datt350 Excel Worksheet Functions 1 June 9th 05 01:04 PM


All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"