calculating ages
 

What is the best way to calculate the age of a person in number of years,
months, days, given their birth date?
Getting the difference between dates in number of days, and dividing by 365
may not be correct to the exact day given leap years. Is there another way?

calculating ages
 

If birth date is in A1 and TODAY() is in B1, then B1-A1 will return the
number of days.

Make sure that the cell in which B1-A1 is is formatted as numbers.

Dave


--
Brevity is the soul of wit.


"pama" wrote:

What is the best way to calculate the age of a person in number of years,
months, days, given their birth date?
Getting the difference between dates in number of days, and dividing by 365
may not be correct to the exact day given leap years. Is there another way?

calculating ages
 

For info on the undocumented DATEDIFF function see Chip's site
www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pama" wrote in message
...
What is the best way to calculate the age of a person in number of years,
months, days, given their birth date?
Getting the difference between dates in number of days, and dividing by
365
may not be correct to the exact day given leap years. Is there another
way?

calculating ages
 

That's what I was looking for, thank you.

"Bernard Liengme" wrote:

For info on the undocumented DATEDIFF function see Chip's site
www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pama" wrote in message
...
What is the best way to calculate the age of a person in number of years,
months, days, given their birth date?
Getting the difference between dates in number of days, and dividing by
365
may not be correct to the exact day given leap years. Is there another
way?