=DATEVALUE(CONCATENATE(RIGHT(LEFT(F2,8),2),"-",RIGHT(LEFT(F2,6),2),"-",LEFT(F2,4)))