If you import dates into Excel from another system, or from the web, they may appear in Excel using a text format. This looks great but will not provide full functionality. Unless you can convert the text into a date format you will not be able to use that data in formulas, PivotTables and other Excel features.
Fortunately, Excel provides a function that can convert text into a date format, and it is very easy to use.
[Read more…] about Convert Text into a Date Format