formula - Age today

A

Althea

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
 
A

Aladin Akyurek

=DATEDIF(D4,TODAY(),"y")

might suffice. The "y" bit stands for Year on Excel English versions.
 
Top