Help w Recurrent Annual Fee - Formula

[slstewart249]

How do I write a formula so that an annual fee shows every 12 months?
Row 10: I have months listed: 1/30/23, 2/28/23 ... etc until 12/31/24.
Row 11: Hard code of Fee and Date annual payment starts. I want to annual fee to show only in June 23 and June 24 (and be able to pick up in future years in June Only.
Thanks!

 

[vletm]

slstewart249
There were some details, which mismatch with Your writings.
Could You show Your - even manually solved - expected results?
... it this sample needs any modifications.

 

[slstewart249]

Hi I revised the spreadsheet to make it clearer and address only annual reocurrent revenue. Appreciate the help!

 

[vletm]

slstewart249
My previous sample has already those elements.
Here my next sample.
You could do needed minor modifications as You would like to have.