Macro to calculate rent amount for entire agreement months

[vinay2210]

Hi Friends,

I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are different. Kindly help me to provide any Macro which can be calculated for entire agreements month (Tenor). I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are different. Kindly help me to provide any Macro which can be calculated for entire agreements month (Tenor). I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are different. Kindly help me to provide any Macro which can be calculated for entire agreements month (Tenor). refer the below table.

Edit: garbled image code removed.

 

[vinay2210]

I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are different. Kindly help me to provide any Macro which can be calculated for entire agreements month (Tenor). I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are different. Kindly help me to provide any Macro which can be calculated for entire agreements month (Tenor). I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are different. Kindly help me to provide any Macro which can be calculated for entire agreements month (Tenor). refer the below table.

 

[vinay2210]

please help me i'm not able to paste the image for this.