This function makes calculating any kind of date comparisons a breeze. You may also use the TODAY function in place of NOW function. NoteTo apply this Add years to date firstly you should download the Kutools for Excel and then apply the feature quickly and easily.
Try the ROUNDDOWN function to calculate age based on birthday as below.
If you have Kutools for Excel with it Add years to date feature you can also calculate the retirement date which on the exact day of birth date after 60 years from the birth date with ease. Calculate age based on the birth of date before 1900. Learn how to format a cell as a number or date. Calculate number of days between dates in Excel with DATEDIF.