å¨excelä¸è®¾ç½®å°æèªå¨æéï¼å¯ä»¥å©ç¨excelä¸çå½æ°datedifæ¥è®¾ç½®ãæ¹æ³å¦ä¸ï¼
å¨B2åå
æ ¼è¾å
¥å
¬å¼ï¼=IF(DATEDIF(A2,TODAY(),"d")>0,"è¿æ"&DATEDIF(A2,TODAY(),"d")&"天å°æ","å·²å°æ")ãå
¬å¼è§£æï¼DATEDIF(A2,TODAY(),"d")该å
¬å¼ç¨æ¥è®¡ç®æ¥æååä»å¤©ç¸è·çæ¶é´æ¯å¤å°å¤©ï¼DATEDIFå½æ°ï¼ç¬¬ä¸ä¸ªåæ°æ¯èµ·å§æ¥æï¼ç¬¬äºä¸ªåæ°æ¯ç»ææ¥æï¼ç¬¬ä¸ä¸ªåæ°æ¯è®¡ç®çç»æè¿åçæ¯å¤©æ°ãå¹´æ°ãè¿æ¯ææ°ãç¨ifå½æ°å¤æä¸ä¸ï¼å¦ææ¯å¤§äº0çå°±æ¯æ²¡æå°æçï¼é£ä¹è¿åâè¿æå¤å°å¤©å°æâï¼å°æçæ¾ç¤ºâå·²å°æâï¼å®ç°äºèªå¨å¤æã
ãã注æï¼todayå½æ°æ¯æ失æ§å½æ°ï¼å°±æ¯æ¯å¤©æå¼æ件ä¿åä¸ä¸ï¼å¼æä¼æ´æ°ï¼å¦å¤todayå½æ°çè¿åå¼åå³äºè®¡ç®æºçç³»ç»æ¥æï¼å¦æç³»ç»æ¥æ设置ä¸æ£ç¡®ï¼é£ä¹todayå½æ°çåå¼ä¹ä¸æ£ç¡®ã
追é®ä½ è¯ä¸ä¸å¯¹ä¸å¯¹å¯å¥½ï¼