How can I calculate dates based on a Lease Term divided into periods by number of months. For example if I have a lease start date of 9/1/11 and the rent adjusts according to a schedule such as this:
Months 1-12 - $x/mo
Months 13-24 - $y/mo
Months 25-36 - $z/mo
And so on…
What is a formula I can use to calculate that date for me for any particular month based on 9/11 being month 1?
Any help is much appreciated!
Bookmarks