We can calculate the age in excel with the help of the TODAY function. You might think that you could simply take the difference in days between the current date and the birth date divided by 365. So it looks like Excel changes a year for to the same as in and calculates the difference in days.
The users of our Ultimate Suite dont have to bother about making their own age calculator in Excel - it is only a couple of clicks away.
Then click Kutools Formula Helper Date Time Helper. The following formulas show how to calculate an age group from an age. To calculate the exact age of a person you want to calculate the difference between the current date or any other desired date and the birth date. Excel 2016 Formula to calculate age group from age Thursday 12 April 2018 by Adrian Gordon.