Check out this link...

http://www.cpearson.com/excel/datedif.aspx
--
HTH...

Jim Thomlinson


"Newfie809" wrote:

If the formula for number of years is =Year(latest date)-Year(earlier
date)
this formula only show the nubmer of years, and I would like it to show the
number of years and months. I need help with this formula:

A B C
Year Year Service
01-Sep-89 31-Dec-09= 20 Years

It should be 20 years 4 Months.

(Remembering that teachers only work from September 1, to June 30, of each
year a total of 194 days.

From September 1, 1989 to June 30, 1990 = 1 Year of Service.
I know it only 10 months, but that is their year.

Is there a formula that could caculate the number of years and months.
--
Newfie