Calculating values between dates

[SamuriWilliams]

I am in the process of modelling the cash flow statement for an infrastructure project. It involves a lot of purchases of fixed assets with a variety of purchases dates and different financing periods. All of which need to be added into the cash flow statement. The calculating of the said amounts is straight forward but where I am having a problem is finding a formula that allows me to add the values into the correct monthly entries. So for example an MRI machine is purchased for £1m in Apr (month 4). The financing period is 12 months. Therefore from a cash flow perspective the entries will be from month 4 to month 16. I have tried to find an If formula that allows you to say if the Cash Flow month is equal to the start date and less than or equal to the end date the figure is X, if not zero but excel isn't happy with my efforts ....

Reading through the forums posts someone had previously suggested =IF(AND(R6 >= B1,R6 <= B2, R6, ""). However for me this doesn't work as the end date needs to be less than or equals to and also excel has a problem with the syntax.

Any suggestions?

[SimonLock]

Does this work for you?

[SamuriWilliams]

Oft kind of hope it doesn't as otherwise I have wasted the last month devising a spreadsheet which does exactly this except in long hand.

THanks I will give it a try over the weekend - after I have stopped crying!!! - and get back to you