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?

Answer 1

Hello, yes u can find your birthdate using your month, date, and year.

you need to follow certain steps for the same.

1. Enter your birth date into cell E1 of a blank worksheet.
2. Enter the formula into cell E3: =DATEDIF(E1,TODAY(),"Y")&" Years, "&DATEDIF(E1,TODAY(),"YM")&" Months, "&DATEDIF(E1,TODAY(),"MD")&" Days"
3. Press ENTER.
4. Your current age appears in cell E3 of the worksheet.
   After these steps, you'll be able to find your birthdate