Use the DATEDIF function. This function is documented only in
Excel 2000 help, but it exists in all versions of Excel. See
www.cpearson.com/excel/datedif.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"LTVJim" wrote in message
...
How can I subtract dates and get the answer in years, months,
and days