Repeat for Annually, Quarterly between 2 dates

Hello experts,

I am not sure if I will get a response here but thought I would ask anyways to check if an expert has a suggestion/solution.

I have a file with due dates based on if the frequency is either annually or quarterly.
If annual, use one formula (in cell D4)
If quarterly, use another. (in cell D5)

I want to repeat t for the number of "hits" for annually and quarterly between the Start Date and End Date. I need the result to be in 1 column.

I assume a solution would be in VBA code (some kind of loop..Im not a programmer). Kindly see the attached file with sample data. After viewing, I think you will be able to see more clearly what I am trying to do. Sorry for any confusion but its better to look at the file to understand completely. The difficult part to me is repeating only between the start date and end date.


Grateful for your assistance

Untitled.jpg

Originally Posted by bebo021999

First row of Quarterly, due date 30 Aug 2021, why first start with 30 Sep 2021?

I think it's 60 days after the end of qtr. if its not correct then I could have overlooked something. Let me know if something else doesnt make sense.