=DATEVALUE(MID(D3,5,2)&"/"&RIGHT(D3,2)&"/"&LEFT(D3,4))
Replace D3 with the cell reference you want to convert to a date...
