Monthly Rent Schedule
I am attempting to build a dynamic revenue row for an apartment rent roll that uses dates to calculate monthly rent revenues and increases. Conceptually this is pretty straightforward but I am having a hard time figuring it out.
I need to have a formula that will return the current rent if the expiration date has not occurred and return a future rent if a date has occurred.
For instance
Unit 1 is currently $520, Rent Expiration 02/28/2021, Upon expiration Unit 1 is $575
Rent on 02/01/2021: $520
Rent on 03/01/2021: $575
.
Sounds like you could either write a nested if statement with your date parameters or preferably build a table with the monthly unit rents for whatever time period your looking at and then run an index match to pull the value at X date
Repudiandae sit minima delectus nemo. Qui voluptate occaecati ratione consequatur est tempore velit. Rerum et quae consequatur sapiente beatae temporibus perspiciatis nihil. Voluptas quos explicabo excepturi quia quia iure possimus. Explicabo nobis exercitationem iste enim blanditiis.
Aut debitis voluptatum sequi. Quo est sit aspernatur quia hic. Veniam eveniet consequatur eaque eaque accusantium autem.
Dolorum iure maiores et deserunt. Ea dolor omnis dolor excepturi molestiae fuga nulla. Debitis dolores iure totam voluptatem ipsa. Assumenda molestiae explicabo adipisci quia. Est similique commodi aliquam eum.
Repellendus quas necessitatibus sit officiis inventore harum. Libero id sed inventore minima asperiores hic.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...