hollys2042
New Member
Help! I am new to all of this and need a formula to calculate the number of vacation days granted based on the employee's hire date and the vacation day allotment schedule in the handbook.
After 1 year, 10 days vacation
After 5 years, 15 days vacation
After 10 years, 17 days vacation
After 15 years, 20 days vacation
After 20 years, 25 days vacation
Any help or guidance you could give me would be appreciated! This project kinda landed in my lap and I'm new to using Excel.
Thanks!
Holly
After 1 year, 10 days vacation
After 5 years, 15 days vacation
After 10 years, 17 days vacation
After 15 years, 20 days vacation
After 20 years, 25 days vacation
Any help or guidance you could give me would be appreciated! This project kinda landed in my lap and I'm new to using Excel.
Thanks!
Holly