Spread Amount between two dates at specific intervals

[BeadyBob]

Hello, I have an existing formula that I use on a revenue forecast spreadsheet. It takes an amount and spreads it evenly by month based on a start and end date.
I would like to ask if anyone could help me modify this formula so that the revenue spread will alternate months, hitting every other month instead of every month between the two dates.

Here is the formula: =IFERROR(MAX(0,MIN($I3+1,EDATE(J$1,1))-MAX($H3,J$1))/($I3-$H3+1)*$F3,0)

H=start date
I=end date
J=month column
F=amount

I have attached an image to show an example. If anyone has a suggestion for how to modify the formula to skip months in the spread, I would appreciate very much. Thank you.

 

[myall_blues]

Does this work for you?

=IF(MOD(MONTH(J$2),2)<>0,MAX(0,MIN($I3+1,EDATE(J$2,2))-MAX($H3,J$2))/($I3-$H3+1)*$F3,0)

** Note ** This starts in the first month and skips every month after that. It does not sum correctly if you change it to MOD(MONTH(J$2),2)=0 so that it starts in the second month. I know why but haven't yet found a solution.

 

[BeadyBob]

Wonderful, that did the trick. It will always need it to start in the first month for the purpose I'm using it for, so this solution will work perfectly. Thank you so very much.

 

[myall_blues]

You’re welcome. Thanks for the feedback.