HiThere
I am trying to make a spreadsheet in the following format
I am trying to make a spreadsheet in the following format
Term column c row 1 | 96 columnd row 1 |
Rent | 16500.00 |
Lease date | 15-05-20 |
First payment | 15-05-209 |
Rent increase% | 10% |
increase interval | 12 |
column c row 17 start of rent15-05-20 | 16500 |
This a format of a worksheet i want to make .what I want to do is on the due date that is on 15-05-20 row c17 must be populated with date 15.5.20 and d 17 must show the rent due that month ie 16500 . then on 15-06-19 c18 should show the the date 15=06-20 and d18 show the amount 16500. this should continue until 15 04-21 after which(ie 15.5.21 the increase of 10% should be applied shown in that month and continue. I just cannot think of a way of achiving this . that is no spreadsheet has been attached. any suggestions help will be appreciated shamsu |