Repeat rows for Annually, Quarterly between Start Date and End Date

[pdvsa]

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 (cell D4)
If quarterly, use another. (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
I cant install the the XL2BB (work computer)
below is the link to the file:

TestAutoGen.xlsx

drive.google.com

 

[JamesCanale]

Here is something you might be able to use. I can't look at your file...

Key in the start and end date and it give you all of the quarters that are inclusive and all of the one-year periods from the start date (meaning, if you start on 1/1, it will give you all of the 12/31's in your range)

MrExcelPlayground2.xlsm
	P	Q	R	S
1	Start Date	1/1/2020	Quarters	Years
2	End Date	12/31/2024	3/31/2020	12/31/2020
3			6/30/2020	12/31/2021
4			9/30/2020	12/31/2022
5			12/31/2020	12/31/2023
6			3/31/2021	12/31/2024
7			6/30/2021
8			9/30/2021
9			12/31/2021
10			3/31/2022
11			6/30/2022
12			9/30/2022
13			12/31/2022
14			3/31/2023
15			6/30/2023
16			9/30/2023
17			12/31/2023
18			3/31/2024
19			6/30/2024
20			9/30/2024
21			12/31/2024
Sheet30

Cell Formulas
Range	Formula
R2:R21	R2	=FILTER(SEQUENCE(Q2-Q1+1,1,Q1,1),(MONTH(SEQUENCE(Q2-Q1+1,1,Q1,1))=3)*(DAY(SEQUENCE(Q2-Q1+1,1,Q1,1))=31)+(MONTH(SEQUENCE(Q2-Q1+1,1,Q1,1))=6)*(DAY(SEQUENCE(Q2-Q1+1,1,Q1,1))=30)+(MONTH(SEQUENCE(Q2-Q1+1,1,Q1,1))=9)*(DAY(SEQUENCE(Q2-Q1+1,1,Q1,1))=30)+(MONTH(SEQUENCE(Q2-Q1+1,1,Q1,1))=12)*(DAY(SEQUENCE(Q2-Q1+1,1,Q1,1))=31),"")
S2:S6	S2	=FILTER(SEQUENCE(Q2-Q1+1,1,Q1,1),(MONTH(Q1-1)=MONTH(SEQUENCE(Q2-Q1+1,1,Q1,1)))*(DAY(Q1-1)=DAY(SEQUENCE(Q2-Q1+1,1,Q1,1))),"")
Dynamic array formulas.