æ ¹æ®æå½å³å¨é¨é¨çæå ³è§å®ï¼ç·æ»¡60å¨å²åçéä¼ï¼å¥³æ»¡55å¨å²åçéä¼ãæ ¹æ®è¿ä¸ªç¹æ§ï¼å¯ä»¥ç¨å½æ°å ¬å¼æ¥åéä¼æéã
å¦ä»¥ä¸ç¤ºä¾æ°æ®ï¼å¨Dåè¾å ¥å ¬å¼ï¼=IF(AND(C2="ç·",60-DATEDIF(B2,TODAY(),"y")=0),MONTH(B2)&"æ"&DAY(B2)&"æ¥éä¼",IF(AND(C2="女",55-DATEDIF(B2,TODAY(),"y")=0),MONTH(B2)&"æ"&DAY(B2)&"æ¥éä¼",""))ãå ¬å¼è§£æï¼é¦å æ¥å¤æç·å¥³ï¼å 为ç·å¥³çéä¼å¹´é¾ä¸ä¸æ ·ï¼å ¶æ¬¡æ¥å¤æåºçæ¥æåä»å¤©å·®è·çå¹´æ°ï¼å¦æè¿åå¼å60ç¸åçäº0çè¯ï¼å°±æ¯ä»å¹´éä¼ï¼ç´æ¥æ¾ç¤ºæ份åæ¥æå³å¯ãä¸è¬æ¯è¿äºå¨å²çæ¥ï¼å³å¯å»ç¤¾ä¿é¨é¨åçéä¼ã