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