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?
|