Rent Spreadsheet Formulas/ Functions Assistance Please

Hi Everyone,

I am trying to make a rental spreadsheet that moves the week end date each time the rent is paid and if the correct amount is not the outstanding amount is reflected.

My knowledge of excel is limited but I thought I would give it a go, and learn something new. I have spent hours googling but unfortunately due to my limited understanding have found this difficult.

The columns are as follows:
Column B: Rent Due Date
Column C: Rent Start Date (2/2/2021)
Column D: Rent End Date (9/2/2021)
Column E: Number of Days (7 days or 1 week)
Column F: Rent Amount ($335 per week)
Column G: Amount Paid
Column H: Arrears

Do I need Column I: Rent Paid Date?

Any hints, tips or if your feeling generous an actual formula/ function would be greatly appreciated.

Thanks in advance.