å¨ç¥éå
¥èæ¥æçåæä¸ï¼èªå¨è®¡ç®åºä¸¤ä¸ªæåç转æ£æ¥æï¼å
¬å¼ï¼
=DATE(YEAR(A1),MONTH(A1)+2,DAY(A1))
A1为å
¥èæ¥æã
1.举ä¾è¯´æï¼å æ¥ççåå§æ°æ®ï¼æ¥ææ¯ææ¬æ ¼å¼çææ¥å¹´ã
2.éä¸æ¥æä¸åã
3.æå¼æ°æ®é项ä¸çãååãã
4.éæ©ãåé符å·ãï¼ç¹å»ä¸ä¸æ¥æé®ã
5.æ¥çï¼éæ©ç¬¬ä¸ä¸ªé项ï¼ç¶åç¹å»ä¸ä¸æ¥ã
6.è¿æ¯å ³é®ï¼è¦åè¯Excel第ä¸ä½æ¯æï¼ç¶åæ¯æ¥ï¼ç¶åæ¯å¹´ï¼äºæ¯éæ©æ ¼å¼ä¸ºâMDYâï¼ç¹å»å®æã
7.è¿æ¯è½¬æ¢ä»¥åå¾å°çæ¥æã