求大神赐教Excel的年假函数计算公式！

2025-04-06 17:53:51

推荐回答（3个）

回答1：

=IF(B$2-G10>365*10,15,IF(B$2-G10>365*5,10,IF(B$2-G10>365*3,8,IF(B$2-G10>365*1,6,0))))

回答2：

J10公式：
=LOOKUP(DATEDIF(G10,TODAY(),"y"),{0,1,3,5;0,6,8,10})

补充问题：
J10公式：

=ROUND((H$2-F$2)/365*LOOKUP(DATEDIF(G10,"2015/12/31","y"),{0,1,3,5;0,6,8,10}),0)

回答3：

=IF(DAYS360(G10,I9)/360<3,6,IF(AND(DAYS360(G10,I9)/360>=3,DAYS360(G10,I9)/360<5),8,IF(AND(DAYS360(G10,I9)/360>=5,DAYS360(G10,I9)/360<10),10,"超出年限")))