求年假的EXCEL计算公式答:=IF(DATEDIF(G2,TODAY(),"y")=0,"0",IF(DATEDIF(G2,TODAY(),"y")=1,"5",IF(DATEDIF(G2,TODAY(),"y")=2,"7",IF(DATEDIF(G2,TODAY(),"y")>=3,"9",)))DATEDIF(G2,TODAY(),"y")代表计算合同到现在的年数,后面就是根据计算出来的年数用IF根据1年就显示,5,2就显示7,...
如何利用excel 公式 计算年休假?要考虑到当年度有离职的进行折算...答:在K2中输入或复制粘贴下列公式 =IF(E2<DATE(2020,1,1),0,MIN(LOOKUP(G2,{0,1,10,20},{0,5,10,15}),15))或 =IF(OR(E2<DATE(2020,1,1),G2<1),0,MIN(LOOKUP(G2,{1,10,20},{5,10,15}),15))下拉填充
急求excel年假计算公式!!谢谢。答:1、到当天的本公司工作年限(不要月日):=DATEDIF(B3,TODAY(),"y")2、到当天的已工作年限(不要月日):=DATEDIF(D3,TODAY(),"y")3、计算14年12月31日为止的年休假:=(365-EDTEDIF(TEXT(TODAY(),"e")&"-1-1",TODAY(),"d"))/365*LOOKUP(H3,{0,1,10,20},{0,5,10,15})...
求计算年假自动计算Excel公式答:度友,规则过于刻薄了!!!应该是工龄满一年了,年休时间尽量满足员工自主安排,年假天数公式为:=IF(A2<>"",IF(AND(DATEDIF(A2,TODAY(),"Y")>=1,DATEDIF(A2,TODAY(),"Y")<=10),5,IF(AND(DATEDIF(A2,TODAY(),"Y")>10,DATEDIF(A2,TODAY(),"Y")<=20),10,IF(DATEDIF(A2,TODAY()...