=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