Date difference

[mosmas]

I have user who wants to calculate the number of years and months someone has been employed. This is what I had in mind.

we would have a col with Hire Date, Today's and two more columns, one for years and one for months. TO find years, I used this formular: datedif(a2,b2,"Y&quot and it works just fine.

now I need to to calculate the months left. This is where I need your help. Can someone help. Thanks in advance.

Moses.

 

[Neenas19]

Hi there just use "m" in place of "y"

 

[mosmas]

Neenas19:

Thanks I just figure out how. To calculate the months, I just need to subtract 12*the number of years from
=datedif(a2,b2,"m&quot.

Thanks for your input though.

moses