Vacation Tracker

Copper Contributor

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

@JenMc 

 

If you have a sub table with year to holiday like 

 

5 years15
10 years18
15 years22
20 years25

 

you can use lookup or xlookup if you have the latest version of Excel 365 to get the value you need.

@JenMc 

 

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.