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?
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.