|If your importing the date, there is a good chance it will be seen by Excel as TEXT.|
Try this: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
This will work for a string that has; a four digit year 2001, a two digit month 07, and a two digit day 19
With no type of delimiter to separate out the various parts of the string,
you will have to modify the above as needed for other dates.
It's the month and day that usually get fouled up.