Assumptions, hiredate and currentdate are dates only.

=IF(OR(hiredate="",currentdate=""),"",YEAR(current date)-YEAR(hiredate))

or, if you want to get a little fancier, in your example below, it should
actually be 99 whole years (a few days short of 100), you could use the
following formula:

=IF(OR(currentdate="",hiredate=""),"",YEAR(current date)-YEAR(hiredate)-IF(DATE(YEAR(2000),MONTH(currentdate),DAY(currentd ate))<DATE(YEAR(2000),MONTH(hiredate),DAY(hiredate )),1,0))

--
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