çä½ è¾å
¥çæ ¼å¼æ¯ä»ä¹ã
æ
å½¢ä¸ï¼
å¨åå
æ ¼A1è¾å
¥ 2009-10-1ï¼å¨B1è¾å
¥ 2010-12-1ï¼è¿æ ·ä¼å¾å°ä¸¤ä¸ªæ¥ææ ¼å¼çæ°æ®ãå¨C1è¾å
¥ =INT(DATEDIF(A1,B1,"m")/12)&"å¹´"&MOD(DATEDIF(A1,B1,"m"),12)&"æ"
å°±å¯ä»¥äºã
æ
å½¢äºï¼
å¨A1è¾å
¥ '2009-10 ï¼å³åé¢æä¸è±æåå¼å·ï¼ï¼å¨B1è¾å
¥ '2010-12ï¼è¿æ ·ä¼å¾å°ä¸¤ä¸ªææ¬ãå¨C1è¾å
¥ =INT(((LEFT(B1,4)-LEFT(A1,4))*12+MID(B1,FIND("-",B1)+1,2)-MID(A1,FIND("-",A1)+1,2))/12)&"å¹´"&MOD((LEFT(B1,4)-LEFT(A1,4))*12+MID(B1,FIND("-",B1)+1,2)-MID(A1,FIND("-",A1)+1,2),12)&"æ"
å°±å¯ä»¥äºã
温馨提示:答案为网友推荐,仅供参考