calculating ages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pama - 07 Nov 2006 18:40 GMT

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?

Reply to this Message

Dave F - 07 Nov 2006 18:53 GMT

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

Signature

Brevity is the soul of wit.

> 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?

Reply to this Message

Bernard Liengme - 07 Nov 2006 18:56 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 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?

Reply to this Message

pama - 07 Nov 2006 19:21 GMT

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

> For info on the undocumented DATEDIFF function see Chip's site
> www.cpearson.com
[quoted text clipped - 5 lines]
> > may not be correct to the exact day given leap years. Is there another
> > way?

Reply to this Message