各位大佬求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(),"Y")<1,0,25))),"")如有需要可以继续联系!!
excel年假计算公式答:=IF(DATEDIF(A2,TODAY(),"y")+5>10,10,IF(DATEDIF(A2,TODAY(),"y")+5=5,"未满一年无年假",DATEDIF(A2,TODAY(),"y")+5))
求年假的EXCEL计算公式答:=IF(DATEDIF(G2,TODAY(),"y")=0,"0",IF(DATEDIF(G2,TODAY(),"y")=1,"5",IF(DATEDIF(G2,TODAY(),"y")=2,"7",IF(DATEDIF(G2,TODAY(),"y")>=3,"9",)))DATEDIF(G2,TODAY(),"y")代表计算合同到现在的年数,后面就是根据计算出来的年数用IF根据1年就显示,5,2就显示7,...