æ好å ç§æ¹æ³ï¼ç¨today()å½æ°åçæ¥ç®åºå¤©æ°é¤ä»¥365.25ååæ´æ¯ä¸ä¸ªåæ³ï¼
=ROUND((TODAY()-A1)/365.25,0)
è¿æä¸ä¸ªåæ³ï¼excelä¸æä¸ä¸ªå½æ°å表ä¸æ²¡æçå½æ°datedif()ãDATEDIFå½æ°ï¼é¤Excel 2000ä¸å¨å¸®å©ææ¡£ææè¿°å¤ï¼å
¶ä»çæ¬çExcelå¨å¸®å©ææ¡£ä¸é½æ²¡æ说æï¼å¹¶ä¸å¨ææçæ¬çå½æ°å导ä¸ä¹é½æ¾ä¸å°æ¤å½æ°ãä½è¯¥å½æ°å¨çµåè¡¨æ ¼ä¸ç¡®å®åå¨ï¼å¹¶ä¸ç¨æ¥è®¡ç®ä¸¤ä¸ªæ¥æä¹é´ç天æ°ãææ°æå¹´æ°å¾æ¹ä¾¿ã微软称ï¼æä¾æ¤å½æ°æ¯ä¸ºäºä¸Lotus 1-2-3å
¼å®¹ã
该å½æ°çç¨æ³ä¸ºâDATEDIF(Start_date,End_date,Unit)âï¼å
¶ä¸Start_date为ä¸ä¸ªæ¥æï¼å®ä»£è¡¨æ¶é´æ®µå
ç第ä¸ä¸ªæ¥ææèµ·å§æ¥æãEnd_date为ä¸ä¸ªæ¥æï¼å®ä»£è¡¨æ¶é´æ®µå
çæåä¸ä¸ªæ¥ææç»ææ¥æãUnit为æéä¿¡æ¯çè¿åç±»åã
âYâ为æ¶é´æ®µä¸çæ´å¹´æ°ï¼âMâ为æ¶é´æ®µä¸çæ´ææ°ï¼âDâæ¶é´æ®µä¸ç天æ°ãâMDâ为Start_dateä¸End_dateæ¥æä¸å¤©æ°çå·®ï¼å¯å¿½ç¥æ¥æä¸çæåå¹´ãâYMâ为Start_dateä¸End_dateæ¥æä¸ææ°çå·®ï¼å¯å¿½ç¥æ¥æä¸çæ¥åå¹´ãâYDâ为Start_dateä¸End_dateæ¥æä¸å¤©æ°çå·®ï¼å¯å¿½ç¥æ¥æä¸çå¹´ãæ¯å¦ï¼B2åå
æ ¼ä¸åæ¾çæ¯åºçæ¥æï¼è¾å
¥å¹´ææ¥æ¶ï¼ç¨æ线æç横线éå¼ï¼ï¼å¨C2åå
æ ¼ä¸è¾å
¥â=datedif(B2,today(),"y")âï¼C2åå
æ ¼çæ ¼å¼ä¸ºå¸¸è§ï¼ï¼æå车é®åï¼C2åå
æ ¼ä¸çæ°å¼å°±æ¯è®¡ç®åçå¹´é¾ãæ¤å½æ°å¨è®¡ç®æ¶ï¼åªæå¨ä¸¤æ¥æç¸å·®æ»¡12个æï¼æç®ä¸ºä¸å¹´ï¼åå¦çæ¥æ¯2004å¹´2æ27æ¥ï¼ä»å¤©æ¯2005å¹´2æ28æ¥ï¼ç¨æ¤å½æ°è®¡ç®çå¹´é¾å为0å²ï¼è¿æ ·ç®åºçå¹´é¾å
¶å®æ¯æå
¬å¹³çã
=datedif(A1,today(),"y")è¿ä¸ªå
¬å¼ä¹å¯ä»¥å¾å°ä½ è¦çç»æã
温馨提示:答案为网友推荐,仅供参考