There are many ways to calculate a person's age in Excel.
This is related to my job case. Here is the excel formula I used:
=(date-birthdate)/365.25
I've make the video guide (tips n triks / tips n tricks) how to use the formula above in YouTube (in this case we will calculate the voters ages in election day). You can watch the video below (Hope it will help).