Calculating age.

  • Thread starter Thread starter pinehead
  • Start date Start date
P

pinehead

Help, i need to figure out how to put in numerical form the age of thi
person.

I have theire birth date January 15, 2000 i need to find the age.

i tried today()-birthday but it gives me another date form?

Suggestions
 
hi!
assuming the date of birth is in A1

try this!

=DATEDIF(A1,TODAY(),"Y")&"YEARS,"&DATEDIF(A1,TODAY(),"YM")&"MONTHS,"&DATEDIF(A1,TODAY(),"MD")&"DAYS."

-via135
 
You must log in or register to reply here.

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

create calculated field for age in pivot tables 4
Calculating age from date of birth and ignoring if blank 5
"how do I calculate age by using date of birth details" 5
calculate date of birth with an end date and age 1
Count/Calculation According to Age of the Person 1
How do I find age in years from anniversary date (Age funtion)? 1
Excel - Calculate age from DOB in years, months days 7
How do I calculate an age from 2 dates? 3

Back
Top