EXCEL公式,根据身份证号码自动获取生日 和性别
生日获取公式
=IF(VALUE(C6)=1,(TEXT(MID(D6,7,8),"0000-00-00")),TEXT("","0000-00-00"))
性别获取公式
=IF(VALUE(C6)=1,IF(D6="","",IF(MOD(IF(LEN(D6)=15,MID(D6,15,1),MID(D6,17,1)),2)=1,"男","女")),"1")
生日获取公式
=IF(VALUE(C6)=1,(TEXT(MID(D6,7,8),"0000-00-00")),TEXT("","0000-00-00"))
性别获取公式
=IF(VALUE(C6)=1,IF(D6="","",IF(MOD(IF(LEN(D6)=15,MID(D6,15,1),MID(D6,17,1)),2)=1,"男","女")),"1")