I am trying to convert a date format. example from 20170417 to 4/17/2017. The date format options in excel keep trying to change it to 3/14/2001.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Date converting
1
Answers
1
if date is in column A then use =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)). You need to break out the 'Date' function into its 3 components. Year, Month then Day.
Let us know if it worked!