Excel convert date format dd.mm.yy to date

If you want to convert a date in toe format dd.mm.yy to a supported date, make a cell containing:

=(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))