1
=IFERROR(IFERROR(TEXT(DATE(LEFT(A2,4),MID(A2,FIND(".",A2)+1,2),MID(A2,FIND("~",A2)-2,2)),"yyyymmdd")&"~"&TEXT(DATE(MID(A2,FIND("~",A2)+1,4),MID(A2,FIND("~",A2)+6,2),RIGHT(A2,2)),"yyyymmdd"),TEXT(DATEVALUE(LEFT(A2,FIND("~",A2)-1)),"yyyymmdd")&"~"&TEXT(DATEVALUE(MID(A2,FIND("~",A2)+1,LEN(A2)-FIND("~",A2))),"yyyymmdd")),TEXT(DATE(MID(A2,FIND("~",A2)-4,4),MID(A2,FIND("/",A2)-1,FIND("/",A2)-1),MID(A2,FIND("/",A2)+1,FIND("~",A2)-6-FIND("/",A2))),"yyyymmdd")&"~"&TEXT(DATE(RIGHT(A2,4),MID(A2,FIND("~",A2)+1,FIND("/",A2,FIND("~",A2))-FIND("~",A2)-1),MID(A2,FIND("/",A2,FIND("~",A2))+1,FIND("/",A2,LEN(A2)-5)-FIND("/",A2,FIND("~",A2))-1)),"yyyymmdd"))