Build rotating schedule for 4th and 5th Sunday

[FryGirl]

In the attached table, I would like to fill in the 4th and 5th Sunday with the rotating schedule in F2:F8. If it's one of the first three Sunday's, in should say "Off Topic" in column D. Column D has the example as it should be.

Schedule.xlsx
	A	B	C	D	E	F
1	Month	Count	Day	Hdr1		Schedule
2	5	1	2-May-21	Off Topic		Schedule A
3	5	2	9-May-21	Off Topic		Schedule B
4	5	3	16-May-21	Off Topic		Schedule C
5	5	4	23-May-21	Schedule A		Schedule D
6	5	5	30-May-21	Schedule B		Schedule E
7	6	1	6-Jun-21	Off Topic		Schedule F
8	6	2	13-Jun-21	Off Topic		Schedule G
9	6	3	20-Jun-21	Off Topic
10	6	4	27-Jun-21	Schedule C
11	7	1	4-Jul-21	Off Topic
12	7	2	11-Jul-21	Off Topic
13	7	3	18-Jul-21	Off Topic
14	7	4	25-Jul-21	Schedule D
15	8	1	1-Aug-21	Off Topic
16	8	2	8-Aug-21	Off Topic
17	8	3	15-Aug-21	Off Topic
18	8	4	22-Aug-21	Schedule E
19	8	5	29-Aug-21	Schedule F
20	9	1	5-Sep-21	Off Topic
21	9	2	12-Sep-21	Off Topic
22	9	3	19-Sep-21	Off Topic
23	9	4	26-Sep-21	Schedule G
24	10	1	3-Oct-21	Off Topic
25	10	2	10-Oct-21	Off Topic
26	10	3	17-Oct-21	Off Topic
27	10	4	24-Oct-21	Schedule A
28	10	5	31-Oct-21	Schedule B
29	11	1	7-Nov-21	Off Topic
30	11	2	14-Nov-21	Off Topic
31	11	3	21-Nov-21	Off Topic
32	11	4	28-Nov-21	Schedule C
33	12	1	5-Dec-21	Off Topic
34	12	2	12-Dec-21	Off Topic
35	12	3	19-Dec-21	Off Topic
36	12	4	26-Dec-21	Schedule D
Sheet2 (2)

Cell Formulas
Range	Formula
A2:A36	A2	=MONTH(C2)
B2:B36	B2	=IF(N(A2),COUNTIF(A$2:$A2,A2),"")
C3:C36	C3	=C2+7

 

[Fluff]

How about

=IF(B2>3,INDEX($F$2:$F$8,MOD(COUNTIFS(B$2:B2,">3")-1,7)+1),"Off Topic")

 

[FryGirl]

That is perfect. Thank you Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.