ä¸ããDateDifãå½æ°æ¯ä¸ä¸ªéèå½æ°ï¼å¨excelçå ¬å¼ä»¥å帮å©ä¸æ¯æ¾ä¸å°çï¼å¿ é¡»è¦æå·¥è¾å ¥æå¯ä»¥ã
æ¤å½æ°çæ ¼å¼ä¸ºã=datedifï¼"æ¥æ1"ï¼"æ¥æ2"ï¼"åæ°"ï¼ãï¼è¯´æå¦ä¸ï¼
1ãæ¥æ1ï¼è®¡ç®çå¼å§æ¥æ
2ãæ¥æ2ï¼è®¡ç®çç»ææ¥æ
3ãåæ°ï¼è®¾å®æ¤å½æ°éè¦è¿åçå 容
äºãæ¥æ1åæ¥æ2ï¼è¿ä¸ªåæ°å¯ä»¥å¡«åçå 容为ï¼
1ãYï¼è¿å两个æ¥æçé´éå¹´
2ãMï¼è¿å两个æ¥æçé´éæ
3ãDï¼è¿å两个æ¥æçé´é天
4ãYMï¼ä¸¤ä¸ªæ¥æä¸ææ°çå·®ï¼å¿½ç¥æ¥æä¸çæ¥åå¹´ã
5ãYDï¼ä¸¤ä¸ªæ¥æä¸å¤©æ°çå·®ï¼å¿½ç¥æ¥æä¸çå¹´ï¼ä½æ¯ä¸å¿½ç¥æã
6ãMDï¼ä¸¤ä¸ªæ¥æä¸å¤©æ°çå·®ï¼å¿½ç¥æ¥æä¸çæåå¹´ã
ä¸ã举ä¾å¦å¾ã
1ã第ä¸ä¸ªå ¬å¼ï¼è®¡ç®äºä»å¤©ã2013-11-12ãä¸â1990-01-01âä¹é´çå¹´æ°é´éï¼ä¹å°±æ¯é´éäº23å¹´ï¼çäºã2013-1990ãçç»æã
2ã第äºä¸ªå ¬å¼ï¼è®¡ç®äºä»å¤©ã2013-11-12ãä¸â1990-01-01âä¹é´çæ份é´éï¼è®¡ç®ç»æå¾ç¥ä¹å°±æ¯é´éäº283个æã
3ã第ä¸ä¸ªå ¬å¼ï¼è®¡ç®äºä»å¤©ã2013-11-12ãä¸â1990-01-01âä¹é´ç天æ°é´éï¼è®¡ç®ç»æå¾ç¥é´éäº8716天ã
4ã第åä¸ªå ¬å¼ï¼è®¡ç®äºä»å¤©ã2013-11-12ãä¸â1990-01-01âä¹é´çâ忽ç¥äºå¹´åæ¥âçæ份é´éï¼ä¹å°±æ¯11æå1æä¹é´çé´éï¼ç»ææ¯10个æã
5ã第äºä¸ªå ¬å¼ï¼è®¡ç®äºä»å¤©ã2013-11-12ãä¸â1990-01-01âä¹é´çâ忽ç¥äºå¹´âçæ¥æé´éï¼ä¹å°±æ¯11æ12æ¥å1æ1æ¥ä¹é´çé´é天æ°ï¼ç»ææ¯315天ã
6ã第å ä¸ªå ¬å¼ï¼è®¡ç®äºä»å¤©ã2013-11-12ãä¸â1990-01-01âä¹é´çâ忽ç¥äºå¹´åæâçæ¥æé´éï¼ä¹å°±æ¯12æ¥å1æ¥ä¹é´çé´é天æ°ï¼ç»ææ¯11天ã