This might work for you...
=DATE(YEAR(O1)+(P1*ROUNDUP((YEAR(TODAY()) - YEAR(O1))/P1,0)),MONTH(O1),DAY(O1))
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
This might work for you...
=DATE(YEAR(O1)+(P1*ROUNDUP((YEAR(TODAY()) - YEAR(O1))/P1,0)),MONTH(O1),DAY(O1))
Thank you so much!!! thats worked perfectly, you are a legend!!
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
Bookmarks