Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Dec 2009
    Location
    Somerset
    Posts
    26
    Thanks
    3
    Thanked 0 Times in 0 Posts

    finish date formula needed

    Col A2 number of years say 5 years
    Col B2 start Date say 11th September 2013
    Col C2 last payment due to show 11th August 2018

    I want to know what the formula in Cell C2 should be
    to automatically give the correct answer in C2.
    It is a finish date so 5 years starting 11th September 2013 of 60 monthly payments
    the last payment should show the 11th August 2018.
    Thought it was an easy one to do, but am stumped for a formula that actually works.
    Help!
    Many thanks
    Jim

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi jimboba

    see attached file.

    My formula in cell [C2] is
    =DATE(YEAR(B2)+A2,MONTH(B2)-1,DAY(B2))

    zeddy
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Dec 2009
    Location
    Somerset
    Posts
    26
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Many thanks
    just the ticket..
    Regards
    Jim

  4. #4
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Another version using EDATE

    =EDATE(B2,(A2*12)-1)

Posting Permissions

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