用EXCEL中的函数来计算年休假,请高手给个公式答:这是按以7月1日为一个临界点的,设A1为入职日期,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...
excel年假和带薪事假计算公式答:以第二行数据为例 D2单元格(年休)输入 =IF(YEAR(B2)<2013,1,(DATEDIF(B2,"2013-12-31","d")+1)/365)*5 如果取整前面加个INT套进去 =INT(IF(YEAR(B2)<2013,1,(DATEDIF(B2,"2013-12-31","d")+1)/365)*5)E2单元格输入(带薪事假)输入 =IF(YEAR(C2)<2013,1,(DATEDIF(C2,...
excel年假计算公式答:=MIN(IF(DATEDIF(A2,B2,"y")>0,DATEDIF(A2,B2,"y")+4+0.5*INT(DATEDIF(A2,B2,"ym")/6),0.5*INT(DATEDIF(A2,B2,"ym")/6)),10)
Excel公式计算年假,求高手帮忙!答:假设你入职日期在A列,从A2开始(A1是表头)B2(工龄)输入 =IF(A2<>"",DATEDIF(A2,NOW(),"Y")&"年"&DATEDIF(A2,NOW(),"YM")&"个月","")C2(年假天数)输入 =IF(A2<>"",MIN(LOOKUP(DATEDIF(A2,NOW(),"Y"),{0,1,5,10},{0,5,10,15})+(IF(DATEDIF(A2,NOW(),"Y")>=...
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...