decent_boy
Board Regular
- Joined
- Dec 5, 2014
- Messages
- 130
- Office Version
- 2016
- Platform
- Windows
Hi
I need a formula to calculate yearly rent as per agreement date, rent will be increased after each year according to annual increment . Enclosed image is an example formula is required in yellow highlighted cells which calculates yearly amount as per billing month cell for example if agreement start year is Jan 2018 and bill year is Jan 2020 then rent amount after 2 year is 60,500. Further if bill year great than agreement end date then it shows "Agreement Expired"
I need a formula to calculate yearly rent as per agreement date, rent will be increased after each year according to annual increment . Enclosed image is an example formula is required in yellow highlighted cells which calculates yearly amount as per billing month cell for example if agreement start year is Jan 2018 and bill year is Jan 2020 then rent amount after 2 year is 60,500. Further if bill year great than agreement end date then it shows "Agreement Expired"