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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]Frequency[/TD]
[TD]£ amount[/TD]
[/TR]
[TR]
[TD]01/01/2016[/TD]
[TD]3[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]01/02/2016[/TD]
[TD]3[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]01/03/2016[/TD]
[TD]6[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]01/04/2016[/TD]
[TD]4[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]Frequency[/TD]
[TD]£ amount[/TD]
[/TR]
[TR]
[TD]01/01/2016[/TD]
[TD]3[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]01/02/2016[/TD]
[TD]3[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]01/03/2016[/TD]
[TD]6[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]01/04/2016[/TD]
[TD]4[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]