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.
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.
Last edited by a moderator: