Hi, I have a formula that gives me an employees start date and with that I was able to determine their allowed vacation days based on one year of service the minimum (thanks CalcSux78).
My problem is, we hired some new employees and the chart won't populate dates less than one year.
I have a chart on sheet 2 with the following info.
<tbody>
</tbody>
The formula is:
=INDEX(Sheet2!$B$2:$B$6,MATCH(YEAR(TODAY()-I31)-1900,Sheet2!$A$2:$A$6,1),0)
The rule is as followes - 6 months= 6 days vacation, 5 months= 5 days vacation, 4 months= 4 days vacation, 3 months= 3 days vacation, 2 months= 2 days vacation and 1 month= 1 day vacation.
How could I add these new rules to the above formula?
My problem is, we hired some new employees and the chart won't populate dates less than one year.
I have a chart on sheet 2 with the following info.
YEARS(S) | DAYS OFF |
1 | 10 |
3 | 15 |
9 | 20 |
18 | 25 |
25 | 30 |
<tbody>
</tbody>
The formula is:
=INDEX(Sheet2!$B$2:$B$6,MATCH(YEAR(TODAY()-I31)-1900,Sheet2!$A$2:$A$6,1),0)
The rule is as followes - 6 months= 6 days vacation, 5 months= 5 days vacation, 4 months= 4 days vacation, 3 months= 3 days vacation, 2 months= 2 days vacation and 1 month= 1 day vacation.
How could I add these new rules to the above formula?