Time with Company Formula

[Lester601]

I know the date of hire for an employee.
Is there a formula that would tell me how long the employee was with the company?

 

[shades]

Are you wanting the number of days, months or years, or fractions of? Are you considering only workdays? What about holidays?

 

[Lester601]

Years with months as a decimal place eg: 10.6

 

[texasalynn]

so if the date hired is in D10 and the current date is in D11
=DATEDIF(D10,D11,"y")&" years"

HTH
texasalynn

 

[Lester601]

Thanks but it s not giving me the months as a decimal place. Any suggestions?

 

[shades]

Try this:

=(DATEDIF($D$10,$D$11,"ym"))/12+DATEDIF($D$10,$D$11,"y")&" years"

 

[bam12]

=(YEAR(E7)-YEAR(hiredate))-(((DATE(YEAR(E7),MONTH(hiredate),DAY(hiredate)))-E7)/365)

Not sure if this will help, but it is what I use to tall years of employment.

HIREDATE equals the cell with the hire date. Example (1/4/1985)

E7 in my formula is actually date of end of our payweek. Which you could make current date. Hope this helps

 

[Lester601]

Shades, Thank you it worked..

Thanks for all other input too.