calculating ages

[Guest]

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?

 

[Guest]

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

 

[Bernard Liengme]

For info on the undocumented DATEDIFF function see Chip's site
www.cpearson.com
best wishes

 

[Guest]

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

For info on the undocumented DATEDIFF function see Chip's site
www.cpearson.com
best wishes