![]() |
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. |
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