Convert text string to date

AK · Feb 1, 2006

How do you convert a text string, "112905" to a date of 11/29/05?

So it has the appropriate serial value 38685 for 11/29/05.

Thanks in advance

David Billigmeier · Feb 1, 2006

Try this:

=DATE("20"&RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))