Excel表格中怎么计算工龄工资?答:1、先在某一个角落的单元输入2019-4-1(日期格式),我们选F1,做好后可以隐藏此列;2、填好员工姓名及入职日期;3、D1 员工“甲”的“工龄工资”计算公式为:=IF(DATEDIF(C2,$F$1,"y")<1,0,IF(DATEDIF(C2,$F$1,"y")=1,40,IF(DATEDIF(C2,$F$1,"y")>1,40+((DATEDIF(C2,$F...
如何在excel里设置工龄公式,并计算工龄工资?答:一、计算工龄工资工式 =IF(DATEDIF(A3,NOW(),"m")>=3,"50",IF(DATEDIF(A3,NOW(),"m")>=12,"100",IF(DATEDIF(A3,NOW(),"m")>=24,"150",IF(DATEDIF(A3,NOW(),"m")>=36,"200","0")))二、计算工龄 1、=DATEDIF(A2,NOW(),"d") (天数)2、=DATEDIF(A2,NOW(),"m...