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

Checkout:

http://www.cpearson.com/excel/datedif.htm
--
Gary's Student


"malvis" wrote:

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

Thank you Gary's Student.

From the site I found to get simple age:

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

"malvis" wrote:

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

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.
--
Rebecca


"malvis" wrote:

Thank you Gary's Student.

From the site I found to get simple age:

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

"malvis" wrote:

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

You're better off using:

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

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

--
Regards,
Fred


"RamseyR" wrote in message
...
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.
--
Rebecca


"malvis" wrote:

Thank you Gary's Student.

From the site I found to get simple age:

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

"malvis" wrote:

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

On Wed, 19 Oct 2005 22:43:42 -0600, "Fred Smith" wrote:

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

On Wed, 19 Oct 2005 22:43:42 -0600, "Fred Smith" wrote:

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