Hi,
I'm trying to convert 161017 to date 10/17/16 using VBA. I thought Cdate function would work but no luck. Thanks for help.

ValueDate = Cdate(Format(Worksheets("Data").Range("A1").Value, "YY/MM/DD"))