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?