How do I calculate ones age as of todays date?

K

kandikane

I need help to calculate ones age as of todays date. I used the YEAR formula
which calculates the years between two dates. The birth date is 12/19/39 and
the formula is returning 65, which is in correct it should be 64 because
12/19/04 has not occured yet which leads me to think that the formula is just
calculating from the year and not the month and day. If anyone could help me
I would appreciate it.
 
N

Nikki

=DATEDIF(A17,B17,"y") a17 being today's date, b17 being date of birth, and y
meaning in years
 
M

Myrna Larson

YEAR returns the year portion of a date. So 2004-1939 is 65.

If you want only years and the birthdate is in A1.

=DATEDIF(A1,TODAY(),"Y")
 

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

Expanding Date Formula 0
calculate average values for 100 records in the shortest way? 5
Excel - Calculate age from DOB in years, months days 7
Age Formula 15
create calculated field for age in pivot tables 4
Search closest day in the past from today 2
Calculating age from date of birth and ignoring if blank 3
"how do I calculate age by using date of birth details" 6

Top