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.
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.
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!