Yes if should. There is an undocumented (apart form XL200 I believe)
function called DATEDIF. With the start date in E1 and the end date in F1
try:

For years: =DATEDIF(E1,F1,"y")
For months: =DATEDIF(E1,F1,"ym")
For days: =DATEDIF(E1,F1,"md")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"FA" wrote in message
...
I want to be sure how long has been since 1/18/88 to 9/30/05. If I
substract
the numbers it says 9/12/17. Can I interpret that as 17 years, nine month
and
17 days? It just that it looks as the answer should be 8 months and not
nine.

Please help.
Thank you!