Hello,

I'm trying to write a macro to do this function:

=DATE(RIGHT(e2,4),LEFT(e2,LEN(e2)-6),LEFT(RIGHT(e2,6),2))

I attempted to record the macro and then used an existing loop function off
another part of code to loop through all dates in column E but is not working
too well.

Thank you very much,


--
Thank You!