1.éè¦ç¨å°ä¸¤ä¸ªå½æ°ï¼
DATE(year,month,day) ï¼Year åæ° year å¯ä»¥ä¸ºä¸å°åä½æ°åã
TODAY() è¿åå½åæ¥æçåºåå·ã
2.两个æ¥æä¹é´ä¸å
±è¿å»äºå¤å°å¤©å¯ä»¥æ两个æ¥æç´æ¥ç¸åå³å¯ï¼å¨excelå½ä¸ï¼todayå½æ°è¿åå½å¤©çæ¥æï¼é£ä¹æ们å¯ä»¥ä½¿ç¨ =TODAY()-DATE(2016,1,2) ï¼è¡¨ç¤º2016å¹´1æ2æ¥å°ä»å¤©è¿å»äºä¸å¤©ï¼è¿å代表ç¹å®æ¥æçåºåå·ãå¦æå¨è¾å
¥å½æ°åï¼åå
æ ¼æ ¼å¼ä¸ºâ常è§âï¼åç»æå°è®¾ä¸ºæ¥ææ ¼å¼ã å¦å¾ï¼