Gregg Wolin
Member
I am trying to eliminate the need for helper columns while tracking lease rates based on a schedule of dates.
Each lease period has a beginning date, an end date and a lease rate. I'd like to create a single column array that looks at a dynamic spill-range of dates, and returns the corresponding lease rate associated each date. The attached workbook better illustrates what i'm talking about. Any suggestions would be greatly apprciated.
Each lease period has a beginning date, an end date and a lease rate. I'd like to create a single column array that looks at a dynamic spill-range of dates, and returns the corresponding lease rate associated each date. The attached workbook better illustrates what i'm talking about. Any suggestions would be greatly apprciated.