Hi,
I am trying to determine the amount of PTO & bonus PTOs that will be earned in a particular year given the employee's length of service. Length of service will determine the amount of PTO earned, as well as any PTO bonuses for anniversaries (1 year, 3 years of service) in that year.
The issue I am having is vlooking up the results from the Datedif formula against the criteria. How can I modify the VLOOKUP data to properly lookup from the correct bucket? Or, do I need to modify the lookup table?
As such, how can I incorporate the bonuses for employees who have achieved anniversary dates?
Thanks,
Bookmarks