员工花名册常用函数公式？
- IT攻略
- 2023-11-23 23:30:02
- 91
简介1.与身份证号码相关的函数，提取性别=IF(MOD(MID(C13,17,1 ,2 ,"男","女" 2.与出生日期相关的函数，计算年龄=DATEDIF(E13,TODAY( ,"y" 3.与入职日期相关的函数，计算司龄=DATEDIF(B...
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")&"天"