Compute Birthdate From Age

293 Views Asked by At

I have an interesting problem. I want to compute a birthdate (Month Date, Year) from a given age. I understand that subtracting the given age from the current date will supply the year of birth, but what about the month and date? Any thoughts are welcome.

1

There are 1 best solutions below

2
On

You cannot calculate the month and day without some information about the portion less than a year. Would you be given the age as 84 years and 256 days old? If it is, it probably should be calculated in excel or something easy like that. The cell reference would be =(NOW()-A1*365-A2) formatted as a date. Place the number of years in A1 and number of days in A2. I used excel only because almost everyone has it.