Formula that will represent years & months worked

P

Pam

I am trying to figure out a formula that will calculate how many years &
months an employee has worked for the company. I found a formula that will
give me the years, but not years & months.
 
P

Pam

I followed Mike's instruction =today()-hiredate, however I do not have YY:MM
under Special or Custom formatting, how do I obtain this selection?
 
R

Ron Rosenfeld

I am trying to figure out a formula that will calculate how many years &
months an employee has worked for the company. I found a formula that will
give me the years, but not years & months.
Click to expand...

=DATEDIF(hire_date,TODAY(),"y") & " years "
& DATEDIF(hire_date,TODAY(),"ym") &" months"


--ron
 
D

Dave Peterson

Select Custom and just type it in the Type: box.

I followed Mike's instruction =today()-hiredate, however I do not have YY:MM
under Special or Custom formatting, how do I obtain this selection?
Click to expand...
 
Top