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

```Age = 14d, 3m, 55y
Today = 13/01/2021
Birthdate = ?```
Feb 16, 2022 in Others 1,341 views

## 1 answer to this question.

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"`
• 13,670 points

## Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

## Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

## Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

## Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE