Spreadsheet: 725136d1616556152-formulae-for-dates-and-period-calculations-that-can-auto-calculate-with-drop-down-example-13-
Sheet: DATA

 | Monthly Rent | Date Paid | Rent Paid | Monthly Rent | Date Paid | Rent Paid | Monthly Rent | Date Paid | Rent Paid | Monthly Rent | Date Paid | Rent Paid | Monthly Rent | Date Paid | Rent Paid | Monthly Rent | Date Paid | Rent Paid
2018-12-01 00:00:00 |  |  |  | 25000 | 2019-01-12 00:00:00 | 25000
2019-01-01 00:00:00 |  |  |  | 25000 | 2019-02-16 00:00:00 | 25000
2019-02-01 00:00:00 | 40000 | 2019-03-12 00:00:00 | 40000 | 25000 | 2019-03-11 00:00:00 | 25000
2019-03-01 00:00:00 | 40000 | 2019-04-13 00:00:00 | 40000 | 25000 | 2019-04-10 00:00:00 | 25000
2019-04-01 00:00:00 | 40000 | 2019-05-20 00:00:00 | 40000 | 25000 | 2019-05-16 00:00:00 | 25000
2019-05-01 00:00:00 | 40000 |  |  | 25000
2019-06-01 00:00:00 | 40000 | 2019-07-04 00:00:00 | 40000 | 25000 | 2019-07-05 00:00:00 | 25000
2019-07-01 00:00:00 | 40000 | 2019-08-04 00:00:00 | 40000 | 30000 | 2019-09-19 00:00:00 | 30000
2019-08-01 00:00:00 | 40000 | 2019-09-04 00:00:00 | 40000 | 30000 | 2019-10-11 00:00:00 | 30000
2019-09-01 00:00:00 | 40000 | 2019-11-07 00:00:00 | 40000 | 30000
2019-10-01 00:00:00 | 40000 | 2019-12-07 00:00:00 | 40000 | 30000
2019-11-01 00:00:00 | 40000 |  |  | 30000
2019-12-01 00:00:00 | 40000 |  |  | 30000 | 2020-01-10 00:00:00 | 30000
2020-01-01 00:00:00 | 40000 |  |  | 30000 | 2020-01-10 00:00:00 | 12000
2020-02-01 00:00:00 | 40000 |  |  | 30000 | 2020-01-18 00:00:00 | 12500
2020-03-01 00:00:00 | 40000 |  |  | 30000
2020-04-01 00:00:00 | 40000 |  |  | 30000 | 2020-03-06 00:00:00 | 35000
2020-05-01 00:00:00 | 40000 |  |  | 30000
2020-06-01 00:00:00 | 40000 | 2020-07-15 00:00:00 | 80000 | 30000
2020-07-01 00:00:00 | 40000 |  |  | 30000
2020-08-01 00:00:00 | 40000 |  |  | 30000 | 2020-07-16 00:00:00 | 50000 | 20000 | 2020-09-09 00:00:00 | 20000
2020-09-01 00:00:00 | 40000 |  |  | 30000 |  |  | 20000 | 2020-10-12 00:00:00 | 20000 |  |  |  | 15000 | 2020-09-01 00:00:00 | 15000
2020-10-01 00:00:00 | 40000 |  |  | 30000 | 2020-09-17 00:00:00 | 10000 | 20000 | 2020-11-10 00:00:00 | 20000 |  |  |  | 15000 | 2020-10-12 00:00:00 | 15000 | 15000 | 2020-10-03 00:00:00 | 15000
2020-11-01 00:00:00 | 40000 |  |  | 30000 | 2020-09-17 00:00:00 | 36000 | 20000 | 2020-12-03 00:00:00 | 20000 |  |  |  | 15000 | 2020-11-16 00:00:00 | 15000 | 15000 | 2020-11-04 00:00:00 | 15000
2020-12-01 00:00:00 | 40000 |  |  | 30000 |  |  | 20000 | 2021-01-12 00:00:00 | 20000 |  |  |  | 15000 | 2020-12-14 00:00:00 | 15000 | 15000 | 2020-12-03 00:00:00 | 15000
2021-01-01 00:00:00 | 40000 |  |  | 30000 |  |  | 20000 | 2021-02-10 00:00:00 | 20000 | 16500 | 2021-01-13 00:00:00 | 16500 | 15000 | 2021-01-13 00:00:00 | 15000 | 15000 | 2021-01-04 00:00:00 | 15000
2021-02-01 00:00:00 |  |  |  | 30000 | 2021-02-15 00:00:00 | 60000 | 20000 | 2021-03-08 00:00:00 | 20000 | 16500 | 2021-02-11 00:00:00 | 16500 | 15000 | 2021-02-13 00:00:00 | 15000 | 15000 | 2021-02-02 00:00:00 | 15000
2021-03-01 00:00:00 |  |  |  | 30000 |  |  | 20000 |  |  | 16500 | 2021-03-11 00:00:00 | 16500 | 15000 | 2021-03-13 00:00:00 | 15000 | 15000 | 2021-03-03 00:00:00 | 15000
2021-04-01 00:00:00 |  |  |  | 30000 |  |  | 20000 |  |  | 16500 |  |  | 15000 |  |  | 15000
2021-05-01 00:00:00 |  |  |  | 30000 |  |  | 20000 |  |  | 16500 |  |  | 15000 |  |  | 15000
2021-06-01 00:00:00 |  |  |  | 30000 |  |  | 20000 |  |  | 16500 |  |  | 15000 |  |  | 15000
2021-07-01 00:00:00 |  |  |  | 30000 |  |  | 20000 |  |  | 16500 |  |  | 15000 |  |  | 15000
2021-08-01 00:00:00 |  |  |  | 30000 |  |  |  |  |  | 16500 |  |  | 15000 |  |  | 15000
2021-09-01 00:00:00 |  |  |  | 30000 |  |  |  |  |  | 16500 |  |  |  |  |  | 15000
2021-10-01 00:00:00 |  |  |  | 30000 |  |  |  |  |  | 16500
2021-11-01 00:00:00 |  |  |  | 30000 |  |  |  |  |  | 16500
2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 16500
2022-01-01 00:00:00
2022-02-01 00:00:00
2022-03-01 00:00:00
2022-04-01 00:00:00
2022-05-01 00:00:00
2022-06-01 00:00:00
2022-07-01 00:00:00
2022-08-01 00:00:00
2022-09-01 00:00:00
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00