ExcelBanter - ages/date of birth

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ages/date of birth (https://www.excelbanter.com/excel-worksheet-functions/18667-ages-date-birth.html)

irishchick28

ages/date of birth

If I have the age of a person in one cell how do i get their date of birth in
the next cell? Is there a formula?

Trevor Shuttleworth

Assuming you know their birthday this year (in cell A1) and their age this
year (in cell B1), one way is:

=IF(A1=TODAY(),DATE(YEAR(A1)-B1,MONTH(A1),DAY(A1)),DATE(YEAR(A1)-B1-1,MONTH(A1),DAY(A1)))

Regards

Trevor

"irishchick28" wrote in message
...
If I have the age of a person in one cell how do i get their date of birth
in
the next cell? Is there a formula?

All times are GMT +1. The time now is 01:49 PM.