Don't forget to format your result cell as general, or it will show up as a
date.
--
John C


"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