Forum Discussion
Excel Formula Help: Reflecting Dynamic Monthly Credit Card Payments by Date
The Goal:
To display the correct monthly payment amount (from the Debt Schedule tab) on the Main Worksheet tab, placing each payment under the correct date column (J4:AV4) based on the due date for each credit card.
The Problem:
The Debt Schedule tab lists multiple credit cards and a month-by-month payoff schedule. As each card is paid off (listed lowest balance to highest), its scheduled payment rolls over and is added to the next card’s payment.
However, the formula I’m currently using on the Main Worksheet tab does not capture these changing payment amounts over time. I need a formula or approach that dynamically reflects the evolving monthly payment amounts as cards are paid off.
Google Drive Link: https://docs.google.com/spreadsheets/d/1jPYLWfuOxEtxF3Mvfo5PFUTsE3_x_5iH/edit?usp=share_link&ouid=102575009763592887799&rtpof=true&sd=true
1 Reply
Your Google Sheet link requires sign-in, I don’t have a google account
....but you can put this formula in the Main Worksheet where the row = card and column = month:
= XLOOKUP($A6,
'Debt Schedule'!$A:$A,
XLOOKUP(J$4,
'Debt Schedule'!$1:$1,
'Debt Schedule'!$A:ZZ,0),0)
Make sure your header row (J4:AV4) contains real Excel dates (not text).
Your Debt Schedule month headers should also be real Excel dates.Hope this helps you.
