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.