If A1 contains text in YYYYMMDD format, use

=DATEVALUE(TEXT(A1,"0000\/00\/00"))