Vacation Entitlement

Question

Tenure	Vacation entitlement
1 year but less then 4 years	4%, 14 days
3 or more years but less then 10	6%, 21 days
10 or more years	8%, 28 days
15 or more years	10%, 35 days

I have the file as follows

NAME    | HIRE DATE | TODAY | YEARS |   %   | VACATION Entitlement

I am unsure how to calculate all this information into one sheet. I'm still learning the formulas, but I am not sure where to begin when it gets into multiple details.