excel年假计算公式答:=IF(DATEDIF(A2,TODAY(),"y")+5>10,10,IF(DATEDIF(A2,TODAY(),"y")+5=5,"未满一年无年假",DATEDIF(A2,TODAY(),"y")+5))
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...
求计算年假自动计算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计算年假公式?答:度友,规则过于刻薄了!!!应该是工龄满一年了,年休时间尽量满足员工自主安排,年假天数公式为:=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()...
在excel中怎样计算年假答:请问81821985 ,假如=TODAY()返回2012-1-1,入职时间是2011-12-31,入职满一年吗?正解为:设A1为入职日期,A2为计算年假的另一参考日期(可以是=TODAY()),=IF(DATEDIF(A1,A2,"Y")>4,MIN(10,DATEDIF(A1,A2,"Y")),IF(DATEDIF(A1,A2,"Y")>0,5,INT((A2-A1)/365*5)))或 =IF(...
要用Excel做一张年假表,根据员工职级和工龄,判断年假天数,怎么用一个公...答:如图 E2输入=IF(AND(C2>6,OR(D2="一级",D2="二级")),16,IF(AND(C2>6,D2="三级"),12,IF(AND(C2>6,OR(D2="四级",D2="五级")),11,IF(AND(C2>=4,OR(D2="一级",D2="二级")),14,IF(AND(C2>=4,D2="三级"),10,IF(AND(C2>=4,OR(D2="四级",D2="...