Formula for Years of Service

[mermar]

I am trying to auto calculate the years of service of employees based on their date of hire. I have a formula that works, however, I have to change the date in the formula each time I create a new employee. Here is the formula I am using, =(TODAY()-DATE(2002,1,22))/365.25. Is there a way to change it using a date I enter into a certain cell instead of the date?

 

[jmthompson]

If you enter your date in A1

=(TODAY()-A1)/365.25

 

[mermar]

Thanks! I just needed to take out the DATE

 

[mermar]

Can the formula cell be blank or 0 if there is no date entered in the Hire date cell?

 

[Scott Huish]

Or you could use DATEDIF

=DATEDIF(A1,TODAY(),"y")

 

[jmthompson]

=if(a1=0,"",(today()-a1)/365.25)

 

[mermar]

=if(a1=0,"",(today()-a1)/365.25)

That worked Great, Thanks!

 

[mermar]

Or you could use DATEDIF

=DATEDIF(A1,TODAY(),"y")

Thanks!