How to calculate time between two dates?

[ByGolly!]

I need to calculate the time interval in years, months, and days between
two calendar dates. For example, what is the time between 12/3/41 and
2/12/2005?

TIA

Frank

 

[Paul B]

Frank, have a look here
http://www.cpearson.com/excel/datedif.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003