D2单元格出生日期计算公式:
=IF(C2="","",VALUE(MID(C2,7,4)&"/"&MID(C2,11,2)&"/"&MID(C2,13,2)))
E2单元格年龄计算公式:
=IF(C2="","",YEAR(TODAY())-MID(C2,7,4))
F2单元格籍贯计算公式:
=IF(C2="","",LOOKUP(VALUE(LEFT(C2,2)),{11,"北京市";12,"天津市";13,"河北省";14,"山西省";15,"内蒙古自治区";21,"辽宁省";22,"吉林省";23,"黑龙江省";31,"上海市";32,"江苏省";33,"浙江省";34,"安徽省";35,"福建省";36,"江西省";37,"山东省";41,"河南省";42,"湖北省";43,"湖南省";44,"广东省";45,"广西壮族自治区";46,"海南省";50,"重庆市";51,"四川省";52,"贵州省";53,"云南省";54,"西藏自治区";61,"陕西省";62,"甘肃省";63,"青海省";64,"宁夏回族自治区";65,"新疆维吾尔自治区";71,"台湾省";81,"香港特别行政区";82,"澳门特别行政区";"","0"}))
G2单元格性别计算公式:
=IF(MOD(MID(C2,17,1),2)=0,"女","男")
H2单元格工龄计算公式:
=DATEDIF(B2,TODAY(),"y")&"年"&DATEDIF(B2,TODAY(),"ym")&"月"&DATEDIF(B2,TODAY(),"md")&"天"
联系客服