求计算年假自动计算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,1,1),"y")),15),0)C2为 上年已休年假天数,请自行输入上年已休天数,D2为 本年可休年假天数,请输入公式:=MIN(IF(DATEDIF(A2,DATE(YEAR(TODAY()),1,1),"y")=0,0,6+DATEDIF(A2,DATE(YEAR(TODAY()),1,1),"y")),15)E2为 本月可休年假天数,请输入公式:=B2-C2+D2 ...