I want to see (expected) monthly cash flow for each customer, and I would like to do this with a formula that reads the start month/year of the contract, applies the calculations to the appropriate months, and halts calculations on the month/year of contract end (leaves blank cells)
In the attached spreadsheet, I come close to achieving this for customer #1, but my formula goes one month too far in applying a cash flow. For this customer, the start date is September 2011, the contract length is 2 years, and this means the final month should be August 2013. My formula shows the final month as September 2013, which is actually 1 month more than the contract length.
Also, some of the contract lengths will be longer or shorter than 2 years, so the formula must take this into account. To the see the formula I was working with, check range T4:BC4. This will hopefully provide more insight into what I am needing.
Bookmarks