Return a value every 3 months from a start date

[fasullo]

Hi, If I have a start date of 7/4/2016, end date 12/31/18 and I need $15,000 to appear on July 2016, then October 2016, then January 2017, every 3 months until the end date --> what formula does this?

Column A

<tbody>
[TD="bgcolor: #6AA84F, align: center"]Invoice Start Date[/TD]
[TD="align: center"]Invoice End[/TD]
[TD="bgcolor: #6AA84F, align: center"]Invoice Amount[/TD]
[TD="align: right"]7/31/2016[/TD]
[TD="align: right"]8/31/2016[/TD]
[TD="align: right"]9/30/2016[/TD]
[TD="align: right"]10/31/2016[/TD]
[TD="align: right"]11/30/2016[/TD]
[TD="align: right"]12/31/2016[/TD]
[TD="align: right"]1/31/2017[/TD]

[TD="align: right"]7/4/2016[/TD]
[TD="align: right"]12/31/2018[/TD]
[TD="align: right"]15,000[/TD]
[TD="align: right"]15,000[/TD]

[TD="align: right"]15,000[/TD]

[TD="align: right"]15,000[/TD]

[TD="align: right"]7/4/2016[/TD]
[TD="align: right"]12/31/2018[/TD]
[TD="align: right"]15,000[/TD]

[TD="align: right"]7/8/2016[/TD]
[TD="align: right"]12/31/2018[/TD]
[TD="align: right"]4,000[/TD]

[TD="align: right"]7/12/2016[/TD]
[TD="align: right"]12/31/2018[/TD]
[TD="align: right"]2,000[/TD]

</tbody>

https://docs.google.com/spreadsheets/d/1uGh3xO0fFdMWzoW6Hjz74zNxjUTSCzLyPdJGY97lrZA/edit?usp=sharing

 

[sheetspread]

You can highlight the first 15,000 (and the 2 blank cells to the right) and copy/paste to the right, or

=IF(MOD(COLUMN(A1),3)=1,15000,"")

in D2 dragged to the right

 

[fasullo]

Thank-you for the reply. this formula is closer. I need the formula to be dynamic if I change the start & end dates.

 

[sheetspread]

This any better:

=IF(AND(D$1>=$A2,D$1<=$B2,MOD(MONTH(D$1)-MONTH($A2),3)=0),$C2,"")


?

 

[fasullo]

perfect! thanks!