D8: =IF(MOD(D5,3)=MOD(MONTH($A$7),3),$A$8,0)
copy accross
Thank you! One more feature to the formula.
If I drag the formula below across the rows, it shows payment each quarter every year. I have a multi-year table.
How would I write it so payment occurs only in 2019?
Thanks
=IF(0+TEXT($A$7,"mm/yyy")<=0+TEXT(DATE(D4,D5,1),"mm/yyy"),IF(MOD(D5,3)=MOD(MONTH($A$7),3),$A$8,0),0)