Hi Pam:

=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"ym")&" months"
will yield:
20 years, 11 months

--
Gary's Student


"Pam Coleman" wrote:

I have personnel records and I want to calculate longevity:
begin date: 1/15/1985 and ending date 12/31/2005.
What is the formula that will calculate the total years and months.

Thanks,