age formula

R

Rhiemma

Can any one help me figure out if it is possible to have a cell reflect
an age based on a date in another cell?
For example:
cell A3 would equal the age of a person based on the person's birthdate
in cell B3 ... How do I get cell A3 to show the age?

Thanks for -any- help!!
 
N

Niek Otten

http://www.cpearson.com/excel/datedif.htm

--
Kind regards,

Niek Otten

|
| Can any one help me figure out if it is possible to have a cell reflect
| an age based on a date in another cell?
| For example:
| cell A3 would equal the age of a person based on the person's birthdate
| in cell B3 ... How do I get cell A3 to show the age?
|
| Thanks for -any- help!!
|
|
| --
| Rhiemma
| ------------------------------------------------------------------------
| Rhiemma's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34386
| View this thread: http://www.excelforum.com/showthread.php?threadid=541683
|
 
S

swatsp0p

With the birthdate in cell A1, use this formula:

=ROUNDDOWN((TODAY()-A1)/365,0)

Format your cell as General with no decimal places to return the Age in
full years.

Does this work for you?

Bruce
 
N

Niek Otten

This doesn't account for leap years. For an older person you could easily be 20 days off.

--
Kind regards,

Niek Otten

|
| With the birthdate in cell A1, use this formula:
|
| =ROUNDDOWN((TODAY()-A1)/365,0)
|
| Format your cell as General with no decimal places to return the Age in
| full years.
|
| Does this work for you?
|
| Bruce
|
|
| --
| swatsp0p
|
|
| ------------------------------------------------------------------------
| swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
| View this thread: http://www.excelforum.com/showthread.php?threadid=541683
|
 
S

swatsp0p

Point taken, Nick. Change the formula to:

=ROUNDDOWN((TODAY()-A1)/365.25,0) takes care of the leap year issue.

DATEDIF requires TWO dates, OP wanted to use just ONE date. OP als
didn't indicate how detailed they wanted the response. My answer give
YEARS only...not likely to be negatively impacted by leap years in mos
people's lifetime.

If OP wants age in years, months, days...then your answer is the way t
go.

Cheers!

Bruc
 

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

Calculating age from date of birth and ignoring if blank 5
Formula to Return age 2
Calulating Age Formula 3
Set non-continuous PrintArea via Function / Name 0
"how do I calculate age by using date of birth details" 5
Excel formula calculating age 4
Giveaway Free copy of Age of Wonders III 2
code to copy range 1

Top