急急急~~~关于年假Excel公式的设置

发布网友发布时间：2022-10-16 12:55

共4个回答

热心网友时间：2023-10-19 04:26

A1是工龄 A2是假期天数:
A2=IF(A1=1,"5",IF(A1=2,"6",IF(A1=3,"7",IF(A1=4,"8",IF(A1=5,"9",IF(A1=6,"10",IF(A1=7,"11",IF(A1=8,"12",IF(A1=9,"13",IF(A1=10,"14",IF(A1=11,"15",IF(A1=12,"16",IF(A1=13,"17",IF(A1=14,"18",IF(A1>=15,"19")))))))))))))))

热心网友时间：2023-10-19 04:26

今年可休天数为：
=IF(DATEDIF(B16,DATE(YEAR(TODAY())-1,12,31),"y")>10,15,IF(DATEDIF(B16,DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),"y")>0,DATEDIF(B16,DATE(YEAR(TODAY())-1,12,31),"y")+4,0))追问不行

追答不好意思，B16是我忘了改地址了，你改一下，改成A1，就是日期所在的格子，你的日期在哪格，就选哪一格的地址
=IF(DATEDIF(A1,DATE(YEAR(TODAY())-1,12,31),"y")>10,15,IF(DATEDIF(A1,DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),"y")>0,DATEDIF(A1,DATE(YEAR(TODAY())-1,12,31),"y")+4,0))

热心网友时间：2023-10-19 04:27

确定工龄：＝INT（（）TODAY（）－E2）/365，E2表示上岗日期

计算年假：在需要显示结果的单元格输入 =IF(Y53>15,15*5,IF(AND(Y53<=15,Y53>=1),Y53*5,0))，Y53表示确定好工龄的单元格。

热心网友时间：2023-10-19 04:27

假如F2单元里是工龄，G2单元格输入如下公式
=IF(F2<1,0,IF(F2<2,5,IF(F2<11,4+F2,15)))