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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Age Formula 15
Excel formula calculating age 4
Conditional age grouping 2
How do I calculate age from birthdate to present in Excel? 4
age groups 8
series of formulas to get to one formula 0
If Formula and Dates 4
Countif function 3

Top