如何利用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如何算年假答:C2公式:不足一天舍去的:=IF(DATEDIF(B2,DATE(YEAR(NOW()),12,31),"Y")=1,INT((DATE(YEAR(NOW()),12,31)-DATE(YEAR(B2)+1,MONTH(B2),DAY(B2)))/365*5),LOOKUP(DATEDIF(B2,DATE(YEAR(NOW()),12,31),"Y"),{0,1,10,20;0,5,10,15}))四舍五入的:=IF(DATEDIF(B2,DATE...
...当年第一年不计算年休假,满10年10天,求excel年休假公式答:...2029 D4=ROUNDDOWN(IF((D$3-YEAR($C4))<1,0,IF((D$3-YEAR($C4))<2,5/12*(12-(MONTH($C4)-1)),IF((D$3-YEAR($C4))<10,5,IF((D$3-YEAR($C4))<11,(MONTH($C4)-1)*5/12+10/12*(12-(MONTH($C4)-1)),10))),0)向右复制 重点当年、第二年、第十年 ...