ä¸ãå设A1ä¸æ¯èº«ä»½è¯å·ç ï¼å¨B2ä¸å½å
¥ä¸é¢çå
¬å¼å设A1ä¸å½å
¥èº«ä»½è¯å·ç ï¼å¨B2ä¸å½å
¥å
¬å¼
=INT((VALUE(TEXT(TODAY(),"YYYYMM"))-VALUE(MID(A1,7,6)))/100)
å³å¯æååºèº«ä»½è¯å·ç ä¸çå¹´é¾
äºãå设A1ä¸å½å
¥çæ¯æ¥æååºçå¹´ææ¥ï¼é£ä¹å¨B1ä¸å½å
¥å
¬å¼
=INT((TEXT(TODAY(),"YYYYMM")-TEXT(A1,"YYYYMM"))/100)
æ
=INT((TEXT(NOW(),"YYYYMM")-TEXT(A1,"YYYYMM"))/100)
å³å¯ç®åºå¹´é¾
温馨提示:答案为网友推荐,仅供参考