Update future date after entering money value in different Cell

[ylliricon]

Hi all.

hope someone can help me with the issue i'm having in excel

Example: I have a mortgage of 85,000 Euros, my Payment plan started on 01/09/2016 and will end on 30/06/2025, I have a monthly payment of 550 Euros per month.

From 01/09/2016 up until end of April 2019 that's 32 months, which mean i have paid 17,600 euros per agreed payment plan ( 32*550=17,600 ).

I have made over payments by 6,050 Euros which brings the total amount to 23,650 Euros if we calculate that in months that would be a total of 43 months of 550 Euros payments,
(43*550=23,650), 43 months from 01/09/2016 comes up to 01/04/2020. which brings me to my question and issue I am having.

What method could i use to automatically update the months (01/04/2020) if I make A SINGLE payment of the minimum required of 550 Euros that date to update to (01/05/2020) or MULTIPLE payments of 550 Euros

I would really appreciate if anyone could formulate the method for this to work as i can not figure this out!!!

Many thanks in advance

 

[oldbrewer]

[TABLE="width: 657"]
<colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]OWING[/TD]
[TD]DATE[/TD]
[TD]PAID[/TD]
[TD]EXTRA PAID[/TD]
[TD]MONTH INT RATE[/TD]
[TD]OUTSTANDING[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]85000[/TD]
[TD="align: right"]01/09/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]84875[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]84875[/TD]
[TD="align: right"]01/10/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]84749.375[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]84749.38[/TD]
[TD="align: right"]01/11/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]84623.12188[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]84623.12[/TD]
[TD="align: right"]01/12/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83946.23748[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83946.24[/TD]
[TD="align: right"]01/01/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83815.96867[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83815.97[/TD]
[TD="align: right"]01/02/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83685.04852[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83685.05[/TD]
[TD="align: right"]01/03/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83003.47376[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83003.47[/TD]
[TD="align: right"]01/04/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82868.49113[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82868.49[/TD]
[TD="align: right"]01/05/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82732.83358[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82732.83[/TD]
[TD="align: right"]01/06/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82596.49775[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82596.5[/TD]
[TD="align: right"]01/07/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82459.48024[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 4"]YOU CAN DRAG DOWN TO MORTGAGE END DATE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ylliricon]

[TABLE="width: 657"]
<tbody>[TR]
[TD]OWING[/TD]
[TD]DATE[/TD]
[TD]PAID[/TD]
[TD]EXTRA PAID[/TD]
[TD]MONTH INT RATE[/TD]
[TD]OUTSTANDING[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]85000[/TD]
[TD="align: right"]01/09/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]84875[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]84875[/TD]
[TD="align: right"]01/10/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]84749.375[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]84749.38[/TD]
[TD="align: right"]01/11/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]84623.12188[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]84623.12[/TD]
[TD="align: right"]01/12/2016[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83946.23748[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83946.24[/TD]
[TD="align: right"]01/01/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83815.96867[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83815.97[/TD]
[TD="align: right"]01/02/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83685.04852[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83685.05[/TD]
[TD="align: right"]01/03/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]83003.47376[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83003.47[/TD]
[TD="align: right"]01/04/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82868.49113[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82868.49[/TD]
[TD="align: right"]01/05/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82732.83358[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82732.83[/TD]
[TD="align: right"]01/06/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82596.49775[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]82596.5[/TD]
[TD="align: right"]01/07/2017[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]82459.48024[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 4"]YOU CAN DRAG DOWN TO MORTGAGE END DATE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you for your replay, that's not quite what i'm looking for

Please see the link ( google spreadsheets ) https://docs.google.com/spreadsheets/d/16kNhnTBwGpYFc6v7crsy7Os6T-JZpxdHMxUYOjlUWl0/edit?usp=sharing

so what I want to figure out is if cell C10 (marked Yellow ) currently showing 43 (months) updates to 44 (months) then that to trigger cell D12 (marked Red)to automatically to update from 03/2020 to 04/2020

Thank you