Kome has attended:
Excel Pivot Tables course
Excel Advanced course
Formula
Hi, i'm trying get a formula that i can use to uplift rent anytime it's up for renewal in the next 10 years. i have the current lease start and end dates for each unit which varies. Is there a formula to return a given value every say 5 years? Thanks for your reply
RE: Formula
Hi Kome
Thank you for using the forum to ask a question.
There isn't an existing Formula for what you want.
PMT function allows you to calculate the Total with Compound interest over a given period of years. I don't think that's what you require though.
You can use the Start and End Dates to calculate how many days the Lease is. Convert this to Months and Years if required. You can Subtract the Current Date from the Lease end to get the remaining days, Months and then Years.
Just need a =SUM formula to multiple the Rent by the days, months or years as required.
Kind regards
Richard Bailey
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
