Results 1 to 4 of 4

Thread: Simple vba formula i need help with

  1. #1

    Simple vba formula i need help with



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    Attached Files Attached Files

  2. #2
    Acolyte gsnidow's Avatar
    Join Date
    Aug 2011
    Location
    Virginia
    Posts
    38
    Articles
    0
    This might work for you...

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

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

  4. #4
    Acolyte gsnidow's Avatar
    Join Date
    Aug 2011
    Location
    Virginia
    Posts
    38
    Articles
    0
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •