Excel-calculating days/months

Greetings,

Some helpful information can be found at the following sites. (REMOVE SPACES from the pasted URL if any snuck in while pasting.)

http://www.mathtools.net/Excel/Time_and_Date/

http://www.erlandsendata.no/english/functions/date/datecalculations.htm

http://www.elementkjournals.com/ime/9612/ime96c3.htm

http://spider.georgetowncollege.edu/wsr/csc120/ssdate97.htm

Good luck.

Maxwell

For a complete discussion of dates in Excel, go to:
http://www.cpearson.com/excel/datetime.htm
In your case here's the formula. It uses a little documented function called DateDif.
With 1/15/01 in A1 and 5/25/01 in A2, the formula is:

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

See Chip Pearson's site for details.
http://www.cpearson.com/excel/datedif.htm