excel年假计算公式答:=IF(DATEDIF(A2,TODAY(),"y")+5>10,10,IF(DATEDIF(A2,TODAY(),"y")+5=5,"未满一年无年假",DATEDIF(A2,TODAY(),"y")+5))
请教一个有关年假天数计算的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)-...
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公式计算年假,求高手帮忙!答:假设你入职日期在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")>=...