Simple vba formula i need help with

[phil_apaya]

i all

i need to produce a formula, i, thinkin LOOP, i need it to take the value in cell 02, then keep addING the value in P2 (which is 5 years) UNTIL todays date has past so that it produces a final date. so for example
For example the first date of 13/08/1999 ni cell 02 will produce a date of 13/08/2014 in cell Q2

please view attatched, any help will be greatly appreciated

[gsnidow]

This might work for you...

=DATE(YEAR(O1)+(P1*ROUNDUP((YEAR(TODAY()) - YEAR(O1))/P1,0)),MONTH(O1),DAY(O1))

[phil_apaya]

Thank you so much!!! thats worked perfectly, you are a legend!!

[gsnidow]

Glad I could help, and thank you for the feedback, as it's always nice for other viewers to know if a solution worked or not.

Greg