ç¨æ°æ®éè§
1ãé¦å
éè¦è¿½å 两个è¾
å©åï¼ä¸ä¸ªæ é¢ä¸ºâæâï¼ä¸ä¸ªæ é¢ä¸ºâå¹´â
2ãå¨æä¸ä¸ä¸ªè¾å
¥å
¬å¼ =text(ä½ çæ¥æå,"yyyymm")
å¨å¹´ä¸ä¸ä¸ªè¾å
¥å
¬å¼ =text(ä½ çæ¥æå,"yyyyâ)
3ãå¡«å
2个å
¬å¼å°ä½ çæ°æ®åºåï¼
4ãæå
¥2个æ°æ®éè§ ï¼ä¸ä¸ªè¡æ ç¾éæ©âæâï¼å¦ä¸ä¸ªè¡æ ç¾éæ©âå¹´âï¼è®¡ç®é¡¹æ¾å¨æ°æ®åºå
5ï¼å®æ
温馨提示:答案为网友推荐,仅供参考