Calculating Age

M

malvis

Thank you Gary's Student.

From the site I found to get simple age:

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

RamseyR

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

Fred Smith

You're better off using:

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

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

Ron Rosenfeld

You're better off using:

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

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

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
 
R

Ron Rosenfeld

You're better off using:

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

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

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
 
Top