Welcome to the forum.
You are going to have to supply more info for someone to help you.
What is your formula that stops working after the current date?
What does each column represent?
- I assume the 916.50 is the monthly payment.
- I assume columns 7 & 8 are a breakdown on interest & principle paid for that month (not sure which is which).