Want to pull out birthdate with given Age and todays date condition

[Shivinder Kaushal]

Hello,

I need assistance in extracting birth date with given Age and current date. Is there any formula to pull out the same. Please assist.

Ex-
Age- 30
Today Date- 26/08/2014 or any other date
Birth Date- ???

Regards
Shivinder Kaushal

 

[Ananda Kumar C]

Could you please be more clear?

Do you want a formula that calculates the birth date of a person, given (i) his / her age (e.g. 30) and (ii) that today is his / her birthday?

If that is the case, you can use this formula: (substitute 30 with whatever cell refers to the age)

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

 

[Shivinder Kaushal]

Please refer the data shared in uploaded sheet.

 

[Shivinder Kaushal]

Could you please be more clear?

Do you want a formula that calculates the birth date of a person, given (i) his / her age (e.g. 30) and (ii) that today is his / her birthday?

If that is the case, you can use this formula: (substitute 30 with whatever cell refers to the age)

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

Hi Ananda,

I have shared sample data in the attached file for better clarity and seeking formula against the same.

Thanks