excel怎么从入职时间来计算工龄和工龄工资，如图来： 根据你的源补充问题修改了一zd下：=VLOOKUP(INT(((YEAR(NOW())-YEAR(B2))*12+(MONTH(NOW())-MONTH(B2))+SIGN(DAY(NOW())-DAY(B2)))/12),{0,50;1,100;5,150;10,200;15,250;20,300;25,350;30,400;35,45