Return to the Windows Tips
Convert value to a Date in Excel
=DATE(LEFT(A1,4), MID(A1,5,2), MID(A1,7,2))
[report a broken link by clicking here]
Return to the Windows Tips
=DATE(LEFT(A1,4), MID(A1,5,2), MID(A1,7,2))
[report a broken link by clicking here]