Simple vba formula i need help with

phil_apaya

New member
Joined
Jan 30, 2013
Messages
5
Reaction score
0
Points
0
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

 

Attachments

  • Tully Query.xlsx
    13.4 KB · Views: 14

gsnidow

New member
Joined
Aug 30, 2011
Messages
38
Reaction score
0
Points
0
Location
Virginia
This might work for you...

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

phil_apaya

New member
Joined
Jan 30, 2013
Messages
5
Reaction score
0
Points
0
Thank you so much!!! thats worked perfectly, you are a legend!!
 

gsnidow

New member
Joined
Aug 30, 2011
Messages
38
Reaction score
0
Points
0
Location
Virginia
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
 
Top