dianemarie
Instructor
Hi, I have to return # of days vacation based on a column that has years tenure. (Tenure is already populated with the number of years an employee has.) What's the quickest way to get this done? Thank you for your help.
Tenure Column Should return days in separate column
0-3 years = 10 days
4-7 years = 15 days
8-14 years 21 days
etc.
So 1 year = 10 days
2 years = 10 days
3 years = 10 days
4 years = 15 days
etc.
Tenure Column Should return days in separate column
0-3 years = 10 days
4-7 years = 15 days
8-14 years 21 days
etc.
So 1 year = 10 days
2 years = 10 days
3 years = 10 days
4 years = 15 days
etc.