Re,
En anglais :
Avec des points dans le n°
=DATE((MID(A7,5,2)+1900+IF(MID(A7,5,2)*1<10,100)),(CHOOSE(MID(A7,8,1)-IF(MID(A7,8,1)*1>4,4),1,4,7,10)+IF(MID(A7,9,2)*1>31,1+IF(MID(A7,9,2)*1>62,1))),MID(A7,9,2)-IF(MID(A7,9,2)*1>31,31+IF(MID(A7,9,2)*1>62,31)))
Sans points, format nombre standard
=DATE((MID(A8,4,2)+1900+IF(MID(A8,4,2)*1<10,100)),(CHOOSE(MID(A8,6,1)-IF(MID(A8,6,1)*1>4,4),1,4,7,10)+IF(MID(A8,7,2)*1>31,1+IF(MID(A8,7,2)*1>62,1))),MID(A8,7,2)-IF(MID(A8,7,2)*1>31,31+IF(MID(A8,7,2)*1>62,31)))
Peu importe le format
=DATE((MID(A9,5-IF(ISNUMBER(A9),1),2)+1900+IF(MID(A9,5-IF(ISNUMBER(A9),1),2)*1<10,100)),(CHOOSE(MID(A9,8-IF(ISNUMBER(A9),2),1)-IF(MID(A9,8-IF(ISNUMBER(A9),2),1)*1>4,4),1,4,7,10)+IF(MID(A9,9-IF(ISNUMBER(A9),2),2)*1>31,1+IF(MID(A9,9-IF(ISNUMBER(A9),2),2)*1>62,1))),MID(A9,9-IF(ISNUMBER(A9),2),2)-IF(MID(A9,9-IF(ISNUMBER(A9),2),2)*1>31,31+IF(MID(A9,9-IF(ISNUMBER(A9),2),2)*1>62,31)))