汉字年月日转数字年月日 (10855)


C2=IFERROR(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"一十","十")&"年",A2),ROW($1:$99)&"年"),"")&IFERROR(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"一十","十")&"个月",A2),ROW($1:$99)&"个月"),"")&IFERROR(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"一十","十")&"天",A2),ROW($1:$99)&"天"),"")


留言