need to figure out a way to take a date and determine how much of an accrual should be added.
In other words, I have their hire date and once they hit 6 months of employment, they receive a certain accrual amount. They accrue this amount until they hit 1 year which is a different accrual amount. The next step is at year 2 and then again at year 5.
How do I create a formula to look at the YOS and determine the highest accrual that they should receive without making a long list of dates?
This is the schedule:
1.00 - 1.99 = 3.08
2.00 - 4.99 = 3.08
5.00 - 9.99 = 4.16
An example would be: Date of hire 06.12.04 should accrue at 3.08
In other words, I have their hire date and once they hit 6 months of employment, they receive a certain accrual amount. They accrue this amount until they hit 1 year which is a different accrual amount. The next step is at year 2 and then again at year 5.
How do I create a formula to look at the YOS and determine the highest accrual that they should receive without making a long list of dates?
This is the schedule:
1.00 - 1.99 = 3.08
2.00 - 4.99 = 3.08
5.00 - 9.99 = 4.16
An example would be: Date of hire 06.12.04 should accrue at 3.08