Calculate Birthdate from an age using y m d in Excel

Question

Is it possible to create a formula to obtain the birth date from an age?

Age = 14d, 3m, 55y
Today = 13/01/2021
Birthdate = ?

Answer 1

Hi To Calculate the date, we can use  Excel's DATEDIF function to calculate a person's current age. If you don't feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue.

 Alternatively, use the function to compute the difference between any two dates.

The DATEDIF function determines a person's current age in years, months, and days in the following formula.

=DATEDIF(E1,TODAY(),"Y")&" Years, "&DATEDIF(E1,TODAY(),"YM")&" Months, "&DATEDIF(E1,TODAY),"MD")&" Days"