monthly income

[shamsu203]

HiThere
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

 

[jasonb75]

Based on my reply in your other thread, you could get the date that you want with

=EOMONTH(TODAY(),-1)+DAY(B18)

The amount is already shown in B21.

 

[dougmarkham]

Hi Shamsu,

See attached. Can be updated, you'll work it out.
Monthly Income.xlsm (Google Drive link)

Kind regards,

Doug

 

[shamsu203]

HI Dough
Tks Iwill have a go at it.

 

[jasonb75]

See attached. Can be updated, you'll work it out.

I think you'll find that posting a file to answer a question without providing the actual answer and an explanation in the thread is against the forum rules.

@shamsu203 see post 2 for a formula that doesn't need you to download a file or 'work it out'.

 

[dougmarkham]

I think you'll find that posting a file to answer a question without providing the actual answer and an explanation in the thread is against the forum rules.

@shamsu203 see post 2 for a formula that doesn't need you to download a file or 'work it out'.

Hi Jason,

Apologies, thanks for letting me know, I wasn't aware of that.

Kind regards,
Doug.