You need the DATEDIF function
http://www.cpearson.com/excel/datedif.htm
--
David Biddulph

"RichC" wrote in message
...
I want to enter two dates. I want know how many years, months, and days
between the dates. Like date of death minus birth date. How long were you
alive?

I can get years and month in separate cells, but the days seem to be an
issue.

Any input would be appreciated.