Repeat for Annually, Quarterly between 2 dates

[Camp2-2]

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

[bebo021999]

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

[Camp2-2]

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.

[JeteMc]

If a formula based solution is acceptable:
The formula for description is: =IF(D11="","",IF(A10="Description",A$4,IF(D11-D10>300,A$4,A$5)))
The formula for frequency and days is: =IF($D11="","",INDEX(B$4:B$5,MATCH($A11,$A$4:$A$5,0)))
The formula for due date is:

Please Login or Register  to view this content.

Let us know if you have any questions.

[kvsrinivasamurthy]

Pl see file. Formulas are from A11:D11.
No helper columns used. all are copied down.