how calculate the date someone had to be born to have a specific a

A

AAlvarez

I am trying o build a formula to calculate the the date someone need to be
born in order to have certaing age.
 
P

pinmaster

Hi,

Try this:

=DATE(YEAR(TODAY()-A1),MONTH(TODAY()),DAY(TODAY()))

where A1 is the age.

HTH
Jean-Guy
 
D

daddylonglegs

If you have the age in years only then you can only get a range. If age as of
today (in years) is in A1 then you can get the latest birthdate by using

=DATE(YEAR(TODAY())-A1,MONTH(TODAY()),DAY(TODAY()))
 
Top