I need help with a formula to calculate how many vacation days someone gets as of 1/1/2014 based on their hire date which is in cell C13.
<1 year of service = 0 days
1 year = 5 days
2 years = 10 days
5 years = 15 days
12 years = 20 days
18 years = 25 days
The tricky part is, if they will hit one of these levels before 1/1/15, we calculate it as if they already hit that level. For example, if someone was hired on 6/1/13, they won't hit 1 year until 6/1/14, but as of 1/1/14 we still show them as having 5 days vacation because they'll hit one year of service before 2015.
Any help would be appreciated! Thank you!
Bookmarks