| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating ages | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How can I create a formula using 2 %'s for 2 sets of ages in the . | Excel Discussion (Misc queries) | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
| Calculating Ages from Birthdates | Excel Discussion (Misc queries) | |||
Linear Mode
