Formula Help

New Contributor



I'm trying to set a vacation tracker to populate vacation days based on years worked.  

0-4 years = 10

5-14 = 15

15-24 = 20

>25 = 25


I want the formula to populate one of those values based on the the employees start date.  I'm not very fluent in excel.


I thought an "IF AND" formula would work but it doesn't.  I tried below: 



If I do just:


it works fine.


Any assistance would be appreicated.

Thank you

3 Replies
best response confirmed by Sergei Baklan (MVP)


Please try it like this...




Or simply this...



Thank you!!! I figured it had something to do with my parenthesis. I appreciate the help and the quick response!

You're welcome @Steve_G12! Glad I could help.