Formula that will represent years & months worked
 

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.

Take a look at Chip Pearson's notes at:
http://www.cpearson.com/excel/datedif.htm

Pam wrote:

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.

--

Dave Peterson

=today()-hiredate
Then format that cell as Special YY:MM

"Pam" wrote:

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.

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?

"Pam" wrote:

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.

On Mon, 29 Aug 2005 10:12:05 -0700, Pam wrote:

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.

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


--ron

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


Pam wrote:

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?

"Pam" wrote:

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.

--

Dave Peterson