ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating ages (https://www.excelbanter.com/excel-discussion-misc-queries/118673-calculating-ages.html)

Lynne

Calculating ages
 
I'm a rank amateur at Excel. I need to calculate children's ages at a given
date. I've tried the formula for calculating days between two dates but I
can't even get that to work.

Dave Peterson

Calculating ages
 
You can subtract any two dates and format that difference as General to get the
number of days between the two dates.

Depending on what you want, you may want to look at Chip Pearson's notes:
http://www.cpearson.com/excel/datedif.htm

Lynne wrote:

I'm a rank amateur at Excel. I need to calculate children's ages at a given
date. I've tried the formula for calculating days between two dates but I
can't even get that to work.


--

Dave Peterson


All times are GMT +1. The time now is 02:27 AM.

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