设ååç¾è®¢æ¥æå¨aåï¼ååæéå¨båï¼ååæææå·²æ为åä½è¾å
¥ï¼ï¼ååç»ææ¶é´å¨cåã
å¨c2è¾å
¥ï¼
=DATE(YEAR(A1),MONTH(A1)+B2,DAY(A1))
è¿å¯ä»¥éè¿é¢è²æ¥æ 注已è¿æçååã
å
·ä½æä½å¦ä¸ï¼
å¨ä¸ä¸ªç©ºç½çåå
æ ¼è¾å
¥ï¼
=today()
ç¶å使ç¨âæ ¼å¼âèå->âæ¡ä»¶æ ¼å¼â->åå«éæ©âåå
æ ¼æ°å¼âï¼âå°äºâåä¹åä¹åè¾å
¥çå½åæ¥æçåå
æ ¼->ç¹å»âæ ¼å¼â->éæ©éè¦æ 注çé¢è²ã
è¿æ ·ï¼å·²è¿æçååï¼å°±è½å·²ç¹æ®çé¢è²è¿è¡åºåã
温馨提示:答案为网友推荐,仅供参考