I have an excel worksheet where I need to list the following:

Date:
Name Hire Date Vacation Earned Days Taken Days
Remaining
Jeff 02/01/2001 10 (days) 3
7

This is the vacation calculation breakdown that I would like to calculate
automatically when I change the days taken. It will calculate lenght of
employment and how much vacation that alllows and updates days remaining
:
First year - 5 days
2-6 yrs - 10 days
7-14 yrs - 15 days
15+ yrs - 20 days

I want to be able to change days taken and have a formula calculate the rest