| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula - Age today
Hi wanting to have a column for age at present day.
Have birthdate info as format dd/mm/yy in column D Tried in Column E (Today() - D4/365) but its way out Any solutions appreciated Many thanks Althea |
|
#2
|
|||
|
|||
|
=DATEDIF(D4,TODAY(),"y")
might suffice. The "y" bit stands for Year on Excel English versions. Althea wrote: Hi wanting to have a column for age at present day. Have birthdate info as format dd/mm/yy in column D Tried in Column E (Today() - D4/365) but its way out Any solutions appreciated Many thanks Althea |
|
#3
|
|||
|
|||
|
MAny thanks
Althea might suffice. The "y" bit stands for Year on Excel English versions. Althea wrote: Hi wanting to have a column for age at present day. Have birthdate info as format dd/mm/yy in column D Tried in Column E (Today() - D4/365) but its way out Any solutions appreciated Many thanks Althea |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Can I use TODAY Function in formula without it changing the next . | Excel Discussion (Misc queries) | |||
| Can I use TODAY Function in a formula that will not change it the. | Excel Discussion (Misc queries) | |||
Linear Mode
