Mastering Development

Dynamic update on excel sheet

I am not that good excel and I am not sure if what I am trying to do it can be done on excel.
I really appreciate if someone can help on this.

I have the following table in excelenter image description here

As you can see Payments left is calculated by matching the first occurrence of value zero and returning the index of that row (I am subtracting 2 because first payment is on row 2).
This work fine right now because first payment is on June 1, 2020 but If I open this spreadsheet 3 months from now it will still say payments left 15. That will not be correct anymore since at that time 3 payments are made so should say payment left 12.
My question is: Is there any way to dynamically know at what row should the calculation of “Payments left” start.
With other words if today is August 15 2020(I can manually enters today’s date if needed), then calculating Payments left should start from September 1, 2020 until the end ?

Leave a Reply

Your email address will not be published. Required fields are marked *