How do I calculate a persn's age in years & months in Excel?

G

Guest

I need to calculate a person's age at a given date in years and months (ie
not 23.8years).

If I cannot calculate in yeras and months I need to be able to round down
the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)

Date of birth in column A, other date in column C

Thank-you
 
G

Guest

One way

In say, D2:
=IF(OR(A2="",C2=""),"",DATEDIF(A2,C2,"y"))
Copy down to return the years.
 
R

Rick Rothstein \(MVP - VB\)

I need to calculate a person's age at a given date in years and months (ie
not 23.8years).

If I cannot calculate in yeras and months I need to be able to round down
the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)

Date of birth in column A, other date in column C
Click to expand...

This should do it...

=DATEDIF(A1,C1,"y")&" years, "&DATEDIF(A1,C1,"ym")&" months"

although months don't switch over until the actual day. That is, for today
(June 30, 2007), someone born on January 30th or earlier will show X years
and 5 months; but if they were born on January 31st, they would show as X
years and 4 months... the 4 wouldn't become 5 until tomorrow (one day later
when the days match up).

Rick
 

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

Excel - Calculate age from DOB in years, months days 7
Calculating age from date of birth and ignoring if blank 5
Calculating age of death 23
How do I calculate a person's age on a specific date? (huge roster 2
Calculate # of years 6
"how do I calculate age by using date of birth details" 5
how do i calculate age in term of years, months, days 3
Excel formula calculating age 4

Top