Excel Formula To Calculate Date Of Birth From Age Complete Guide

First of all you need to calculate to total completed years between a date of birth and todays date. Using TODAY function the date formula in Excel is. DATEDIF E1TODAY Y Years DATEDIF E1TODAY YM Months DATEDIF E1TODAYMD Days To make the formula easier to work with a persons birth date is entered into cell E1 of a worksheet see the example below.

To account for a leap year occurring every 4 years 36525 is used in the formula.

First of all you need to calculate to total completed years between a date of birth and todays date. Before you use the function make sure the data table is formatted properly the cells with dates must be formatted as Date and the cells to display the calculated age need to be formatted as Number. Calculate age on a specific or future date with formula. In the following formula the DATEDIF function determines a persons current age in years months and days.