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

=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
>
>

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