Elapsed dates help needed

C

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.
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top