RevToMkt | ||||||||
Data Type: Date (Optional) | ||||||||
A date number in Excels own system of date numbers, or can also be a decimal year (eg 2001.5, 2002.75). If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). | ||||||||
If no review to market is specified ie it is omitted, NO REVIEW TO MARKET takes place in the main lease. If the function is a reletting function, then there WILL be reviews to market in the subsequent leases, because those reviews depend on the lease start date of the relet. If you want to completely eradicate all reviews to market, set RevMos to a very high number eg 999. | ||||||||
Example: 2010 |