Forum Discussion
Vacation Tracker
Tips on tracking vacation time that days earned reflects on hire date?
Example - 20 days earned after 15 years of employment. Would I use the IF function for this to calculate correctly?
2 Replies
As suggested by erol sinan zorlu, you could use one of the several LOOKUP functions with a table to yield number of days earned based on length of employment.
As you suggested in your first question, you could also use IF or IFS.
A lot would actually depend on how granular the system is within which these vacation days are being earned. Is it a clearly demarked step system, with something happening after precisely five years and every multiple of five thereafter? Or are vacation days earned more gradually during the course of time, even each year? Or is it a combination?
So it would help if you could be more descriptive of the rules that apply in your situation. As is generally true in Excel, there will no doubt be multiple potential answers, but which one is most effective will depend on more details.
If you have a sub table with year to holiday like
5 years 15 10 years 18 15 years 22 20 years 25 you can use lookup or xlookup if you have the latest version of Excel 365 to get the value you need.
