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