Thanks Gary that works brilliant,
The year start date is in another cell and the length of service is years
worked from start date to that date, can i adjust that formula so it
calculates length of service from start date to year start date rather that
today
--
thanks

Mike


"Gary''s Student" wrote:

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