Hi

To calculate leave earned, use the following in C:

=IF(TODAY()-B215*365.25,20,IF(TODAY()-B26*365.25,15,IF(TODAY()-B22*365.25,10,5)))

To calculate remainder use the following in E:

=C2-D2

"Kim" wrote:

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