Calculate next birthday from DoB and age

[surkdidat]

Hi

In Column G I have a date of birth
In Column H I have their age next birthday
In Column I I would like a formula to state the date of their next birthday

For instance

Column G - 02/02/1972
Column H - 53
Column I should then state 02/02/2025

Many thanks

 

[RoryA]

=DATE(YEAR(G2)+H2,MONTH(G2),DAY(G2))

should do it I think.

 

[Phuoc]

Another way:

=EDATE(G2,H2*12)