年假excel计算公式,求高手解决!答:设日期在A1单元格 =IF(DATEDIF(A1,TODAY(),"M")>=240,"15天",IF(DATEDIF(A1,TODAY(),"M")>=120,"10天",IF(DATEDIF(A1,TODAY(),"M")>=12,"5天","")))
请高手相助 EXCEL计算年假的公式答:=IF(DATEDIF(A1,TODAY(),"Y")=1,"5天",IF(DATEDIF(A1,TODAY(),"Y")>1,IF(DATEDIF(A1,TODAY(),"Y")+4<15,DATEDIF(A1,TODAY(),"Y")+4&"天",IF(DATEDIF(A1,TODAY(),"Y")+4>=15,"15天","0天")),"0天"))这个公式参考一下,在A1单元格填入入职日期,然后在其它单元格填入...