求计算年假自动计算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中的函数来计算年休假,请高手给个公式答:B1为年假天数,公式为:=IF(DATEDIF(A1,DATE(YEAR(TODAY()),7,1),"y")+7>15,15,DATEDIF(A1,DATE(YEAR(TODAY()),7,1),"y")+7)如果以入职日为界限的,设A1为入职日期,B1为年假天数,公式为:=IF(DATEDIF(A1,TODAY(),"y")+7>15,15,DATEDIF(A1,TODAY(),"y")+7)...
用Excel计算年假,假设在司工龄小于1年则不能享有年假,工龄小于3年者答:公式如下:=IF(DATEDIF(B7,TODAY(),"y")<1,"无年假",IF(DATEDIF(B7,TODAY(),"y")<3,"10天",DATEDIF(B7,TODAY(),"y")+7&"天"))