如题所述
å¦æ身份è¯å¨Cåï¼
è¾å ¥=DATE(MID(C2,7,4),MID(C2,11,2),MID(C2,13,2)) å¾å°åºçæ¥æ
è¾å ¥=IF(MOD(MID(C2,17,1),2),"ç·","女") å¾å°æ§å«
详è§éå¾