Excel formula: Repeat fixed value every 3 months | Exceljet
https://exceljet.net/formula/repeat-fixed-value-every-3-monthsTo repeat a fixed value every 3 months, you can use a formula based on the DATEDIF and MOD functions. In the example shown, the formula in C4, copied down, is: = IF( B4 >= start , (MOD(DATEDIF( start, B4,"m") + n, n) = 0) * value,0) where "start" is the named range F6, "n" is F4, and "value" is F5. Explanation