Question: how do i convert yyyymmdd to date?
Answer: Step 1: Extract the year. =LEFT(A1,4) => 2018. Step 2: Extract the day. =RIGHT(A1,2) => 25. Step 3: Extract the month. ...  Step 4: Convert each part as a date.