Could someone please help!

I am trying to figure out the person's age as of today. I can figure out the years no problem, but of course, if the person's birthday has not happened yet, it is still saying they are the age they WILL be. Not the age they are.

i.e.

if you were born on 10/1/72, you have not yet turned 36. Tomorrow you will be 36 years old. Today you are still 35. However, my calculations: =Year(Today())-Year(A1), shows a calculation of 36.

Help!

If anyone is interested I found several answers, but the easiest was:

To calculate age in terms of years, months, and days, DATEDIF is a handy function. The following formula is similar to the one above.

=DATEDIF(birthdate,date,"y")

from:

http://excel-formulas.*************/2...-in-excel.html