+ Reply to Thread
Results 1 to 2 of 2

Payoff Dates and Final Payments

  1. #1
    Forum Contributor
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    223

    Payoff Dates and Final Payments

    Hello,

    I have amortization schedules for 2 loan scenarios. I would like the Payoff Dates and Final Payments for each of the 2 loan scenarios that I highlighted in orange on the 'Inputs' sheet. These come from the other 2 sheets but aren't always from the same cells. The Input sheet allows you to change amounts is why.

    Does anyone know how to have the orange cells filled in please?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    223

    Re: Payoff Dates and Final Payments

    I used the MAX function to retrieve the latest dates and then index match to get the amounts.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate Number of Payments To Payoff Loan
    By oldesalt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2018, 01:09 PM
  2. Need to put dates of payments next to the party
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-08-2016, 03:49 PM
  3. Loan Payoff with Variable Payments
    By Safetyjack in forum Excel General
    Replies: 2
    Last Post: 03-11-2015, 01:51 AM
  4. return payoff after "X" amount of payments
    By jermsalerms in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2006, 12:11 PM
  5. how do I sum all of the $ payments made between two dates
    By Andrew in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2006, 04:25 AM
  6. [SOLVED] Calculation with dates:several payments
    By Vanna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2006, 02:35 AM
  7. [SOLVED] Calculating Due Dates Based on Payments
    By Eric Hanson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2005, 11:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1