"Mike" wrote:
..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

Another play ..

Assuming startdates in B2 down,
Put in say, C2:
=VLOOKUP(DATEDIF(B2,--"1-Jan-2007","y"),{1,20;15,21;20,22},2)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---