Formula for calculating age
 

Hi,

What is a good formula for calcluating someone's current age? I have the
date of birth in one column and want to have their current age in the next
column. The fomula I am currently using is great if I have the column of
their age have decimals instead of a whole number...the decimal shows how far
into the year they are...but if I just want a whole number there it rounds it
up...so I guess I would need it to round down, eh? In any case, how would I
do this? Below is the formula I am currently using: =(NOW()-D6)/365

Thanks!
Kathy

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Kathy" wrote in message
...
Hi,

What is a good formula for calcluating someone's current age? I have the
date of birth in one column and want to have their current age in the next
column. The fomula I am currently using is great if I have the column of
their age have decimals instead of a whole number...the decimal shows how
far
into the year they are...but if I just want a whole number there it rounds
it
up...so I guess I would need it to round down, eh? In any case, how would
I
do this? Below is the formula I am currently using: =(NOW()-D6)/365

Thanks!
Kathy

use <datediffunction. see excel help
A1---5/31/1926
B1----7/23/2005
in any cell type
=datedif(a1,b1,"y")
will give you 79


Kathy wrote in message
...
Hi,

What is a good formula for calcluating someone's current age? I have the
date of birth in one column and want to have their current age in the next
column. The fomula I am currently using is great if I have the column of
their age have decimals instead of a whole number...the decimal shows how
far
into the year they are...but if I just want a whole number there it rounds
it
up...so I guess I would need it to round down, eh? In any case, how would
I
do this? Below is the formula I am currently using: =(NOW()-D6)/365

Thanks!
Kathy

This is awesome - thanks!!! I love it!

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Kathy" wrote in message
...
Hi,

What is a good formula for calcluating someone's current age? I have the
date of birth in one column and want to have their current age in the next
column. The fomula I am currently using is great if I have the column of
their age have decimals instead of a whole number...the decimal shows how
far
into the year they are...but if I just want a whole number there it rounds
it
up...so I guess I would need it to round down, eh? In any case, how would
I
do this? Below is the formula I am currently using: =(NOW()-D6)/365

Thanks!
Kathy