Excel人事必会的8个函数

点击上方蓝色字体，查看更多Excel技巧！！！

1、计算工作日天数

=NETWORKDAYS(开始日期，结束日期)

2、统计部门人数

=COUNTIF(C1:C9,F2)

3、员工考核分级

=IF(D2>=90,"优秀",IF(D2>=80,"良好",IF(D2>=60,"及格","不及格")))

4、计算退休日期

=EDATE(C2,IF(D2="男",60,55)*12)

5、身份证号判断年龄

=DATEDIF(DATE(MID(A2,7,4),MID(A2,11,2),MID(A2,13,2)),TODAY(),"Y")

6、身份证号计算出生日期

=DATE(MID(A2,7,4),MID(A2,11,2),MID(A2,13,2))

7、身份证号判断性别

=CHOOSE(MOD(YEAR(B4)-4,12)+1,"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")

今天的分享到这里就结束了，可以点击上方名片关注我，获取更多Excel技巧奥！！！