I currently need help calculating a formula which will generate the number of vacation days earned under the following conditions:
- 10 days for each year of service beginning on the one year anniversary of service
- 15 days for each year of service beginning on the 10 year anniversary of service
The table currently includes (in this order) employee name, date of hire, current date, years worked (I have already developed a formula for the years worked), days earned, days used, current balance. I simply need to create a formula for the days earned column which will automatically update along with my current formula in order to calculate days earned with the given information.
Thanks!
Bookmarks