View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deborah Deborah is offline
external usenet poster
 
Posts: 35
Default Number of years/months/days between 2 dates

I am looking for a formula that gives me the number of years, months and days
between two dates.

e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy)
Result: 7 years, 5 months, 17 days

e.g. 01/01/2005 - 01/03/2006
Result: 1 year, 2 months, 0 days

Thank you for your time.

Deborah