Convert textual dd.mm.yyyy format to actual date format in MS Excel

I have seen this also works in Excel 2007 also:
Goto Dates menu => Then follow Data tab menu
Then click Text To Column button
Delimited – Untick all options (Can also use Fixed Width)
Next
Select Date Option
Finish

Read this forum link for more details

Read this page also : http://www.theexceladdict.com/_t/t040303.htm

To calculate no of years , no of days, and number of months between any two dates : http://www.theexceladdict.com/_t/t040303.htm


Google SEO > SMO > Cost