éä¸åå æ ¼ââå³é®ââ设置åå æ ¼æ ¼å¼ââæ¥æââç±»å
追é®è¿ä¸ªæ¹æ³è¯è¿è¿æ¯ä¸è¡çå
追çæä¸é¢åºå设置为ä¸å½é¦æ¸¯ç¹å«è¡æ¿åº
还是不可以哦
追答试试以下公式:
=DATE(LOOKUP(9E+307,-RIGHT(A1,ROW($1:$15)))+2000,SUBSTITUTE(RIGHT(SUBSTITUTE(A1,D1,""),LEN(SUBSTITUTE(A1,D1,""))-FIND("-",SUBSTITUTE(A1,D1,""))),"月",""),LEFT(SUBSTITUTE(A1,D1,""),FIND("-",SUBSTITUTE(A1,D1,""))-1))