Excel 2007 : Tenure help

[jfarm]

Can someone please help me? I need to figure out the formula to calculate tenure. I have the original hire date of employees and I need to figure out their tenure as of 08/01/2011.

Thanks

[alansidman]

I need to figure out their tenure as of 08/01/2011

What does this mean? Length of service at that point in time? Tell us in simple English what you are trying to do.

[jfarm]

This is what I need. Sorry, I am a newbie.
Last Name First Name Original Date of Hire Tenure as of August 2012

Column C is the hire date
Column D - I need their years of service in years that they will be on August 1, 2012.

[arthurbr]

Hi and welcome to the board

Have a look at the the DATEDIF function

[GeneralDisarray]

you could try this (autored in cell D1 and copied down the "D" column)

=(DATE(2012,8,1)-c1)/365

Make sure to FORMAT THE D column for number (otherwse will give you a number as a date)

--edit---

Also, this will give you a decimal number, were you looking for the whole number of years? number of years to the nearest 1/4, etc?

[daddylonglegs]

Examples always help. If the hire date is 1/1/2000 then what is the expected result in column D? Do you want to show whole years like 12 or should fractional amounts be included like 12.58?

[jfarm]

Example if hire date is 8/1/2011 then it would be expected that D would be 1 year. Fractional amounts would be fine.

The formula above did not work

[jfarm]

This is what I have in there right now for today's date. I would like the same but I need to determine years of service as of 8/1/2012.

=DATEDIF(C2,TODAY(),"y")&"Yr,"&DATEDIF(C2, TODAY(),"ym")&"Mth,"

[daddylonglegs]

Try using your reference date rather than today, i.e.

=DATEDIF(C2,DATE(2012,8,1),"y")&"Yr,"&DATEDIF(C2,DATE(2012,8,1),"ym")&"Mth,"

[jfarm]

Thanks! This last formula worked. I really appreciate it.