英文日期改正式日期 (13418)

C2=DATE(RIGHT(B2,4),LOOKUP(1,0/FIND(TEXT(2020&-ROW($1:$12)&-1,"MMM"),B2),ROW($1:$12)),LEFT(B2,2))

另解=TEXT(REPLACE(REPLACE(B2,3,,"/"),7,,"/")*1,"YYY/MM/DD")