ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date formula question (https://www.excelbanter.com/excel-discussion-misc-queries/145500-date-formula-question.html)

RichC

Date formula question
 
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.

David Biddulph[_2_]

Date formula question
 
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.





All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com