最佳答案:1.与身份证号码相关的函数,提取性别=IF(MOD(MID(C13,17,1),2),"男","女")2.与出生日期相关的函数,计算年龄=DATEDIF(E13,TOD
1.与身份证号码相关的函数,提取性别=IF(MOD(MID(C13,17,1),2),"男","女")
2.与出生日期相关的函数,计算年龄=DATEDIF(E13,TODAY(),"y")
3.与入职日期相关的函数,计算司龄=DATEDIF(B13,NOW(),"y")&"年"&DATEDIF(B13,NOW(),"ym")&"月"&DATEDIF(B13,NOW(),"md")&"天"