ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula - Age today (https://www.excelbanter.com/excel-worksheet-functions/10193-formula-age-today.html)

Althea

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

Aladin Akyurek

=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

Althea

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

All times are GMT +1. The time now is 05:39 AM.