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.

On Fri, 13 Feb 2009 09:33:02 -0800, Cerberus
wrote:

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

Check out this link...

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

Jim Thomlinson


"Cerberus" wrote:

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.

Thank you Mr. Thomlinson.

"Jim Thomlinson" wrote:

Check out this link...

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

Jim Thomlinson


"Cerberus" wrote:

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.

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
"Cerberus" wrote:

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.