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