求用excel计算年假休假的公式答:年假表格为:{0,0;1,5;2,6;3,7;4,8;5,9;6,10;7,11;8,12;9,13;10,15} 工龄在单元格A1,年假计算公式为:=vlookup(a1,{0,0;1,5;2,6;3,7;4,8;5,9;6,10;7,11;8,12;9,13;10,15},2)
excel年假计算公式答:=IF(DATEDIF(A2,TODAY(),"y")+5>10,10,IF(DATEDIF(A2,TODAY(),"y")+5=5,"未满一年无年假",DATEDIF(A2,TODAY(),"y")+5))
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")>=...