You have a typo or two in your description but try this.

June 30, 2010 in A1

September 1, 1998 in A3

In a cell enter

=DATEDIF(A3,A1,"y")&" years, "&DATEDIF(A3,A1,"ym")&" months, " &
DATEDIF(A3,A1,"md") & " days"

Returns 11 years, 9 months, 29 days

Where you get the 21 years 10 months is a mystery to me.


Gord Dibben MS Excel MVP


On Fri, 28 May 2010 12:17:01 -0700, Newfie809 wrote:

June 30, 2010

A B C
D
Birth Date Date of Hire Appt. Int/Act. Appt. VP

November 22, 1962 September 1, 1988 N/A September 1, 1998


Total Admin Service Total Bd Service
E F
11.84 21.84

I am usint June 30 , 2010 as the end date for the formula. From Sept 1,1998
to June 30 I get 11.84 years. this should be 11 years 10 months and then From
Sept 1, 1988 to June 30, 2010 should be 21 years 10 months. I tried to round
up but it would not let me. Can anyone help me figure this out.