ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   calculate childs age Excel (https://www.excelbanter.com/setting-up-configuration-excel/16922-calculate-childs-age-excel.html)

Age calculation in Excel

calculate childs age Excel
 
I am trying to build a Excel spread sheet and I want to calculate the childs
age starting at 2 weeks of age. Then get month age and then year age.

Dave Peterson

Take a look at =datedif().

Chip Pearson has very nice instructions at:
http://www.cpearson.com/excel/datedif.htm



Age calculation in Excel wrote:

I am trying to build a Excel spread sheet and I want to calculate the childs
age starting at 2 weeks of age. Then get month age and then year age.


--

Dave Peterson


All times are GMT +1. The time now is 03:35 PM.

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