Let's assume that the name is in column A and the Service Date is in column B

=20+(DATE(YEAR(B1)+15,MONTH(B1),DAY(B1))<TODAY())+ (DATE(YEAR(B1)+20,MONTH(B1),DAY(B1))<TODAY())

for example:

maxwell 7/25/2002 20
fred 2/5/1992 21
albert 2/6/1900 22

--
Gary''s Student - gsnu200730


"Mike" wrote:

Hi
I am trying to make a holiday sheet , every employee gets 20 days holidays
per year, but if they have worked for us for more than 15 years then they get
an extra day, and another extra day for more than 20 years service, i have a
start date for each employee, how can i get excell to give me the number of
days each employee is entitled to please
--
thanks

Mike