Elapsed dates help needed

[Cerberus]

I am trying to create a formula to calculate how many years and months an
employee has worked for us. In cell K2 we have the date of the report
(12/31/08), in cell G17 we have the hire date (5/6/02). Now in cell I17 we
want the years of service (6) and in cell J17 we want the months (8).

I tried to do something like =K2-G17 and then Ctrl+Shift+~ to get 2431 and
then I did Ans/365.25 to get the number of years (6.655715) but now I can't
figure out how to get to drop the .655715 and use the remainder to multiply
by 12 to get the months.

If you have any ideas on how to do that or if any of you have a better way
to go about get the proper results I would greatly appreciate it.

Thanks in advance.

 

[Ron Rosenfeld]

I am trying to create a formula to calculate how many years and months an
employee has worked for us. In cell K2 we have the date of the report
(12/31/08), in cell G17 we have the hire date (5/6/02). Now in cell I17 we
want the years of service (6) and in cell J17 we want the months (8).

I tried to do something like =K2-G17 and then Ctrl+Shift+~ to get 2431 and
then I did Ans/365.25 to get the number of years (6.655715) but now I can't
figure out how to get to drop the .655715 and use the remainder to multiply
by 12 to get the months.

If you have any ideas on how to do that or if any of you have a better way
to go about get the proper results I would greatly appreciate it.

Thanks in advance.

See your other post
--ron

 

[Jim Thomlinson]

Check out this link...

http://www.cpearson.com/excel/datedif.aspx

 

[Cerberus]

Thank you Mr. Thomlinson.

Check out this link...

http://www.cpearson.com/excel/datedif.aspx

 

[Sheeloo]

You need to use
=Datedif(G17,K2,"y")
in I17

and

=Datedif(G17,K2,"ym")
in J17

See http://www.cpearson.com/excel/datedif.aspx for details