Converting date from various forms to mm/dd/yyyy format

[Sud]

Hi, guys, I am trying to convert the data in a column, "N" which is an output of another macro into mm/dd/yyyy format.

Below are the steps I am trying to perform:

1. Cell will have data in the format: 'some special characters' <space> 'Date' <space> 'timestamp or some string'
2. I have to get the 'Date' thats in the middle and convert it into "mm/dd/yyyy" format.
3. Input Dates can be of the below formats;
dd/mm/yyyy
dd/mm/yy or mm/dd/yy
d/m/yy or m/d/yy
And finally similar dates but instead of '/' we might have "-" or "."

I had written a macro which is as below:
I had taken string length instead of truncating with <space> which gave me errors.
For example:




Input Date Output Date
1/7/10 1/7/2010
1/7/2010 1/7/2010
1/7/2010 1/7/2010
1/7/2010 1/7/2010
20/07/11 11/15/42
Upda 07/20/11 1
1/7/2010 1/7/2010
1/7/2010 1/7/2010
1/7/2010 1/7/2010
7/12/2010 12/7/2010
7/12/2010 12/7/2010

Suggestions please.

[Winon]

You will have to follow the Forum Rules first. Edit your Post and place your code within "Quote Tags".

You do not want to upset the Forum Moderators!

[davesexcel]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.