Calculating Age

[Guest]

Is there a formula that can calculate age when given only Date of Birth?

 

[Guest]

Checkout:

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

 

[Guest]

Thank you Gary's Student.

From the site I found to get simple age:

=DATEDIF(A1,NOW(),"y")

 

[Guest]

I have found an easier way...
=2005-year(a1)

Granted if their DOB is in a month after today it will show how old they
will be this year.. but it's much easier.

 

[Fred Smith]

You're better off using:

=year(today())-year(a1)

This will work next year, whereas a hard-coded 2005 will not.

 

[Ron Rosenfeld]

You're better off using:

=year(today())-year(a1)

This will work next year, whereas a hard-coded 2005 will not.

Both formulas make the (usually) erroneous assumption that a birthday is on
January 1.

This may be OK if that is what is desired, but that's rarely the case, except
for, I believe, horses.

Some school districts have a defined birthday, but the one's with which I am
familiar do not have it on Jan 1.


--ron

 

[Ron Rosenfeld]

You're better off using:

=year(today())-year(a1)

This will work next year, whereas a hard-coded 2005 will not.

Correction to my previous -- I think horse's birthdays being on 1 Jan only
applies to the northern hemisphere. I believe they are born on a different
date in the southern hemisphere (? 1 Aug or 1 Jul)


--ron