I am sure there is an easy solution to this, that I just can't see. I have many payments due quarterly, each with differing start months. For a given month, I need to know if a payment will be due.
For example, using the table below, the £100 in the first row is due in Jan, Apr, Jul, Oct the £200 in second row due in Feb, May, Aug, Nov, etc.
I want a formula to tell me what is due in October. Any ideas? I've tried looking at VBA with something like [Month(StartDate) + Freq * i] and looping through, but I feel there should be an easier way.
<tbody>
</tbody>
For example, using the table below, the £100 in the first row is due in Jan, Apr, Jul, Oct the £200 in second row due in Feb, May, Aug, Nov, etc.
I want a formula to tell me what is due in October. Any ideas? I've tried looking at VBA with something like [Month(StartDate) + Freq * i] and looping through, but I feel there should be an easier way.
Start Date | Frequency | £ amount |
01/01/2016 | 3 | 100 |
01/02/2016 | 3 | 200 |
01/03/2016 | 6 | 50 |
01/04/2016 | 4 | 20 |
<tbody>
</tbody>