å¨å¹´ä»½å½æ°åé¢æ¾ç¤ºâå¹´âå使ç¨è¿æ¥ç¬¦å·&ï¼å°å½æ°å 容ä¸âå¹´âææ¬è¿æ¥ã
è½¯ä»¶å·¥å ·ï¼excel 2013
1ãæ¯å¦æ个年份å½æ°=YEAR(TODAY())ï¼è¯¥å½æ°æ¾ç¤ºä¸º2016ï¼è¦å¨åé¢æ¾ç¤ºä¸ä¸ªå¹´åã
2ãå¨è¯¥å½æ°åé¢å¢å &"å¹´"ï¼å³=YEAR(TODAY())&"å¹´"ã
3ãåé¢å¢å âå¹´âåï¼è¿ä¸ªå±äºææ¬ï¼ä¸æ¯åå æ ¼ï¼æ以è¦ç¨å¼å·""å¼èµ·æ¥ã