满一年以后每年年休假5天,当年第一年不计算年休假,满10年10天,求excel...答:C4=2015-8-10 D3=2015 E3=2016 F3=2017 G3...R3=2018...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)-...
如何用Excel表格计算年假答:2.将光标移动到E7单元格,输入公式=DATEDIF(D7,TODAY(),"y")如图所示,将光标移动到E7单元格右下角鼠标呈十字架状,下拉列表。ps:如果想计算两个时间段的天数,将"y"改成"m"即可。3.下面根据工龄计算出年休假天数。将光标移动到F7.输入公式=HLOOKUP(I7,{0,1,10,20;0,5,10,15},2)。4...
excel年假计算公式答:=IF(DATEDIF(A2,TODAY(),"y")+5>10,10,IF(DATEDIF(A2,TODAY(),"y")+5=5,"未满一年无年假",DATEDIF(A2,TODAY(),"y")+5))