- 7/5/2021变成2021/7/5
=DATE(RIGHT(J2083,4),LEFT(J2083,FIND("/",J2083)-1),MID(J2083,FIND("/",J2083)+1,FIND("#",SUBSTITUTE(J2083,"/","#",2))-FIND("#",SUBSTITUTE(J2083,"/","#",1))-1))
- 7/5/2021变成5/7/2021
=DATE(MID(L2072,FIND("/",L2072)+1,FIND("#",SUBSTITUTE(L2072,"/","#",2))-FIND("#",SUBSTITUTE(L2072,"/","#",1))-1),LEFT(L2072,FIND("/",L2072)-1),RIGHT(L2072,4))