LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default Text dates to date format

Some work with the text to columns but they are not all exactly the same,
Feb 1/04 doesn't work because I guess it isn't Feb 01/04 and sometimes Mar
is
written as March. The DATEVALUE function that bob suggested seems to work
for
most of them and can be modified to work of the ones with only 1 day
value.


Give this formula a try...

=DATEVALUE(MID(A21,FIND(" ",A21)+1,FIND("/",A21)-FIND("
",A21)-1)&"-"&LEFT(A21,3)&"-"&RIGHT(A21,2))

Rick

 
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
Convert date from text format to date format Anita Excel Discussion (Misc queries) 3 June 4th 07 11:57 AM
Convert date + time text format to date format Paul Ho Excel Worksheet Functions 2 May 22nd 07 05:47 PM
Format text 'dates' to real dates Jacy Excel Worksheet Functions 4 July 24th 06 02:10 AM
Text and dates into one cell without loosing date format Hazeltine Excel Discussion (Misc queries) 2 April 25th 06 07:05 PM
Compare dates (one cell not in date format) craigcsb Excel Discussion (Misc queries) 5 June 28th 05 05:07 PM


All times are GMT +1. The time now is 12:19 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"