出生日期:
=IF(LEN(D8)=15,DATE(MID(D8,7,2),MID(D8,9,2),MID(D8,11,2)),IF(LEN(D8)=18,DATE(MID(D8,7,4),MID(D8,11,2),MID(D8,13,2)),""))
性别:
=IF(OR(LEN(D6)=15,LEN(D6)=18),IF(MOD(MID(D6,15,3)*1,2),"男","女"),"")
出生日期:
=IF(LEN(D8)=15,DATE(MID(D8,7,2),MID(D8,9,2),MID(D8,11,2)),IF(LEN(D8)=18,DATE(MID(D8,7,4),MID(D8,11,2),MID(D8,13,2)),""))
性别:
=IF(OR(LEN(D6)=15,LEN(D6)=18),IF(MOD(MID(D6,15,3)*1,2),"男","女"),"")