No, there is no formula. Because it is not clear when you made the payments. But it doesn't matter, because you don't have to enter anything cell by cell. That's what is good about spreadsheets. You enter the forumula once and then copy the formula to as many cells as you like.

I am trying to upload a video (zip) to show you, but I can't do it some error with this website. If you PM me with your email address, I will email it to you