Seniority Years Formula needed

  • Thread starter Thread starter Roibn L Taylor
  • Start date Start date
R

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
 
Try the following formula, changing the cell references to match you worksheet:

=(B1-A1)/365.254
 
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))
 
Back
Top