一、计算工龄工资工式
=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") (月数)
3、=DATEDIF(A2,NOW(),"y") (年数)