身份è¯å·ç¹ç¹ï¼
1ãä½æ°ï¼18ï¼ä¸éç¨ææ¬åå¨
2ã第7ä½å¼å§ç8ä½æ°ä¸ºåºçæ¥æ
3ãåæ°ç¬¬äºä½å¯å¤å®ç·å¥³
éè¦ç¥éå¹´é¾ï¼é£ä¹æ们è¦æèµ·åºçæ¥æï¼ç¶å就使ç¨DATEDIFæåè·ç¦»å½ä»æ¥æå¤å°å¹´ã
1)æååºçæ¥æï¼å¨B2åå æ ¼åä¸å ¬å¼ã
=MID(A2,7,8)
ä»A2åå æ ¼ä¸ç¬¬7ä½å¼å§ï¼å8ä½
2)转æ¢ä¸ºæ åæ¥æï¼å¨C2åå æ ¼åä¸å ¬å¼ã
=--TEXT(B2,"0000-00-00")
ç±midå½æ°ååºçæ°æ®æ¯ææ¬ï¼æ以æ们è¦å°è¿ä¸ªçä¼¼æ¥æçæ°åæ´å½¢ææ¥æï¼ä½¿ç¨textæ´å½¢ï¼åæ0000-00-00ï¼è¿æ¯æ¥æçæ ·å¼ï¼ä½æ¯textå¤ççç»æé½æ¯ææ¬ï¼æ以åå¨åé¢å 2个è´å·ï¼è´è´å¾æ£ï¼è½¬æ¢ææ°å¼ãå°±ä¼å¾å°ä¸ä¸ªæ°åãå
¶å®æ¥ææ¬æ¥å°±æ¯ä¸ä¸ªæ°åãåªæ¯è¡¨ç°çæ ·å¼ï¼å°±æ¯æ们çå°çæ¥æã
3)计ç®å¹´é¾ï¼å¨D2åå æ ¼åä¸å ¬å¼ã
=DATEDIF(C2,TODAY(),"Y")
æå综ååä¸å ¬å¼ï¼
=DATEDIF(--TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"Y")