请问excel中如何用函数计算工龄工资,求高手解答答:比如入职时间在A1 =MIN(IF(AND(MONTH(A1)>=1,MONTH(A1)<4),10+DATEDIF(A1,TODAY(),"y") *10,IF(AND(MONTH(A1)>=4,MONTH(A1)<10),5+DATEDIF(A1,TODAY(),"y") *10,0)),50)最好有一个固定的截止时间,如2014/12/31 =MIN(IF(AND(MONTH(A1)>=1,MONTH(A1)<4),10+DATEDIF(...
excel表格中如何用公式算工龄工资,答:设C2为入职日期,D2为工资结算截止日期如2015-6-30,E2为工龄工资,则在E2输入公式:=IF(DATEDIF(C2,D2+1,"m")<12,0,IF(DATEDIF(C2,D2+1,"Y")=1,100/DAY(D2)*DATEDIF(C2,D2+1,"yd"),(DATEDIF(C2,D2+1,"y")-1)*100))