How to change 20011212 to a date.

Posted by Jack Smith on December 12, 2001 7:51 PM

I there a macro/formula that will change the date 20011212 to a date that Excel will recognize.

Posted by Juan Pablo G. on December 12, 2001 7:57 PM

Try with this one if the middle 12 is month

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

or this one if the month is the *second* 12.

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

Juan Pablo G.

Posted by Jack Smith on December 12, 2001 8:07 PM

Thank you. I wish I had asked a few hours ago.