How To Calculate Age From Future Date In Excel Complete Guide

Select Add option from the Type section. 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 in Excel To calculate Age in Excel we must have the Date of Birth of that person.

In the To section enable the Specific data option and then select the cell containing the certain date you.

Calculate age based on the birth of date before 1900. WORKDAY B250 1 Type this formula into the formula box of the cell C2 and then press Enter key in your keyboard. If you just want to add or subtract from dates you can use the basic arithmetic operations in a formula. One of the easiest ways to calculate the age of anything is to use Excels DATEDIF function.