求计算年假自动计算Excel公答:年假天数计算公式 =IF(DATEDIF(A2,TODAY(),"y")<1,ROUND(DATEDIF(A2,TODAY(),"m")/12*5,0),IF(DATEDIF(A2,TODAY(),"y")<=10,5,IF(DATEDIF(A2,TODAY(),"y")<=20,10,25)))公式向下复制填充即可
求excel中年假的计算方法,入职满1年是5天的年假,未满一年没有年假,以后...答:假设B2单元格是入职日期、C2单元格里是核算日期,则可在D2单元格输入年假天数公式为:=IF(DATEDIF(B2,C2,"Y")<1,0,4+DATEDIF(B2,C2,"Y"))若是要15天封顶的,则公式为:=IF(DATEDIF(B2,C2,"Y")<1,0,MIN(15,4+DATEDIF(B2,C2,"Y")))...
年假计算公式:我想用IF函数。答:提供三条公式,任选一条在 N3 输入下拉即可:公式一:=IF(M3="","",MIN(M3+5,12))公式二:=IF(M3="","",IF(M3+5>=12,12,M3+5))公式三:=IF(M3="","",IF(M3+5<12,M3+5,12))
请教一个有关年假天数计算的excel公式设置问题?答:使用公式:=IF(D2>20,15,IF(D2>10,10,IF(D2>1,5,IF(D2=20,INT((TODAY()-DATE(YEAR(TODAY()),1,1)+1)/365*10)+INT((DATE(YEAR(TODAY()),12,31)-TODAY())/365*15),IF(D2=10,INT((TODAY()-DATE(YEAR(TODAY()),1,1)+1)/365*5+(DATE(YEAR(TODAY()),12,31)-...