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

Invoice Start Date	Invoice End	Invoice Amount	7/31/2016	8/31/2016	9/30/2016	10/31/2016	11/30/2016	12/31/2016	1/31/2017
7/4/2016	12/31/2018	15,000	15,000			15,000			15,000
7/4/2016	12/31/2018	15,000
7/8/2016	12/31/2018	4,000
7/12/2016	12/31/2018	2,000

<tbody>
</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!