Seniority Years Formula needed

[Roibn L Taylor]

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

 

[Gary''s Student]

=DATEDIF(A1,B1,"y")

 

[Kevin B]

Try the following formula, changing the cell references to match you worksheet:

=(B1-A1)/365.254

 

[John C]

Assumptions, hiredate and currentdate are dates only.

=IF(OR(hiredate="",currentdate=""),"",YEAR(currentdate)-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(currentdate)-YEAR(hiredate)-IF(DATE(YEAR(2000),MONTH(currentdate),DAY(currentdate))<DATE(YEAR(2000),MONTH(hiredate),DAY(hiredate)),1,0))

 

[John C]

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

 

[Roibn L Taylor]

Thanks worked perfectly

=DATEDIF(A1,B1,"y")