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"))
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"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks