The simplest way to calculate age in Excel is to use the Excel Yearfrac Function, which returns the fraction of a year between two dates.
In the example spreadsheet below, the Excel Yearfrac function is used to calculate the age, on the date 01/01/2016, of an individual who was born on 03/03/1960:
|3||Age:||=YEARFRAC( B1, B2 )|
The function in cell B3 of the above spreadsheet returns the value 55.82777778.
I.e. on the date 01/01/2016, a person who was born on 03/03/1960, was 55 years old.
If you want to tidy up the above age calculation, so that it returns an integer, rather than a decimal value, this can easily be done using the Excel Int Function, which truncates a supplied number down to the closest integer.
In the spreadsheet below, the Int function is used to truncate the result of the Yearfrac function to an integer.
|3||Age:||=INT( YEARFRAC( B1, B2 ) )|
The function in cell B3 of the above spreadsheet now returns the value 55.
If you want your age formula to calculate the age of an individual on the current date, and to update automatically each day, this can be done using the Excel Today function, which returns the current date.
Therefore, if you replace the value in cell B2 of the above spreadsheet, with the formula =TODAY(), this will be used in the age formula in cell B3.