Date converting

1

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.

Answer
Discuss

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!

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login