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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.