| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate age in excel so I can add it
I need to take a birth date and a future set date to get an age. I need the
age in years to one decimal place. (35.5 years) I then need to add those ages in a group to find the total age of a team of 4. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate age in excel so I can add it
try:
=DATEDIF(A2,B2,"m")/12 A2=Birth date B2=Future date "Joe Phillips" wrote: I need to take a birth date and a future set date to get an age. I need the age in years to one decimal place. (35.5 years) I then need to add those ages in a group to find the total age of a team of 4. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate e^2 in excel | Excel Discussion (Misc queries) | |||
| How to get Excel to calculate | Excel Discussion (Misc queries) | |||
| can't get excel to calculate | Excel Worksheet Functions | |||
| how do i calculate in excel % Available | Excel Discussion (Misc queries) | |||
| how can i calculate uk apr with excel | Excel Worksheet Functions | |||
Linear Mode
