=DATEDIF(A1,B1,"y")
--
Gary''s Student - gsnu200796


"Roibn L Taylor" wrote:

Does anyone know the formula for calculating a person seniority years

i tried subtracting the End Date from Start date / 365 but because of leap
years this does not accurately calculate. any ideas?

Hire Date Current Date =(B2-A2)/365
08/01/1908 07/23/2008 100.04