Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Import data that contains dates coded as text strings

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))