Thread: Formula Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newfie809 Newfie809 is offline
external usenet poster
 
Posts: 61
Default Formula Excel

Wondering if someone would be able to help me with this:

A B C
Year Year Service
01-Sep-89 30-Jun-10 = 21 Years

Teachers
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
from September 1, 1989 to June 30, 2010.









--
Newfie