there is a function called Datedif() which you won't find in help which
should give you what you want.

more information on it can be found on

http://www.cpearson.com/excel/datedif.htm

"LTVJim" wrote:

How can I subtract dates and get the answer in years, months, and days