A few days ago

What is the Excel function for age in total years?

In Excel, lets say my birthday is 2/14/1985 and todays date is obviously 12/2/2007. How can i find out my age in total years?

Top 2 Answers
A few days ago

Favorite Answer

Assuming that your birthdate is in cell A1, I would use the following formula:

=( TODAY() – A1 ) / 365

If you want to display only whole-number years, then use this one:

=ROUNDDOWN ( ( TODAY() – A1 ) / 365, 0 )


A few days ago
Put 2/14/1985 in one cell, and 12/2/2007 in another. Take the difference between the two cells and divide by 365…..22.81 (so 22 years).

Or use the function YEARFRAC(first date, second date).