Fill 7 rows and increment and reset based on date

[kyddrivers]

I am in need of a formula to return a week of month value. Starting with the 15th of the month as 1, and repeat for 7 days or rows and then increment until we get to the 15th of the next month and restart back at 1.

I have INT((ROW()-ROW($F$1))/7)+1) to get the 7 rows and increment by 1, but I am failing to get the reset when I hit the 15th. If I add =IF(DAY(C34)=15, 1, to beginning it returns a 1 on the 15 and goes back to incrementing.

example: Formula in column E =IF(DAY(C28)=15, 1, INT((ROW()-ROW($E$28))/7)+1)

Col C​	Col E
15-Jan-22​	1
16-Jan-22​	1
17-Jan-22​	1
18-Jan-22​	1
19-Jan-22​	1
20-Jan-22​	1
21-Jan-22​	1
22-Jan-22​	2
23-Jan-22​	2

Here is what happens when I get to Feb 15th:

11-Feb-22​	4
12-Feb-22​	5
13-Feb-22​	5
14-Feb-22​	5
15-Feb-22​	1
16-Feb-22​	5
17-Feb-22​	5

How do I reset back to 1 starting on the 15th of the month?

Thanks in advance!

 

[Dossfm0q]

Book1
	A	B
15	13-Jan-2021	5
16	14-Jan-2021	5
17	15-Jan-2021	1
18	16-Jan-2021	1
19	17-Jan-2021	1
20	18-Jan-2021	1
21	19-Jan-2021	1
22	20-Jan-2021	1
23	21-Jan-2021	1
24	22-Jan-2021	2
25	23-Jan-2021	2
26	24-Jan-2021	2
27	25-Jan-2021	2
28	26-Jan-2021	2
29	27-Jan-2021	2
30	28-Jan-2021	2
31	29-Jan-2021	3
32	30-Jan-2021	3
33	31-Jan-2021	3
34	01-Feb-2021	3
35	02-Feb-2021	3
36	03-Feb-2021	3
37	04-Feb-2021	3
38	05-Feb-2021	4
39	06-Feb-2021	4
40	07-Feb-2021	4
41	08-Feb-2021	4
42	09-Feb-2021	4
43	10-Feb-2021	4
44	11-Feb-2021	4
45	12-Feb-2021	5
46	13-Feb-2021	5
47	14-Feb-2021	5
48	15-Feb-2021	1
49	16-Feb-2021	1
50	17-Feb-2021	1
51	18-Feb-2021	1
52	19-Feb-2021	1
53	20-Feb-2021	1
54	21-Feb-2021	1
55	22-Feb-2021	2
56	23-Feb-2021	2
57	24-Feb-2021	2
58	25-Feb-2021	2
59	26-Feb-2021	2
60	27-Feb-2021	2
61	28-Feb-2021	2
62	01-Mar-2021	3
63	02-Mar-2021	3
64	03-Mar-2021	3
65	04-Mar-2021	3
66	05-Mar-2021	3
67	06-Mar-2021	3
Sheet1

Cell Formulas
Range	Formula
B15:B67	B15	=IF(DAY(A15)>=15,CEILING(A15-DATE(YEAR(A15),MONTH(A15),14),7)/7,CEILING(A15-DATE(YEAR(A15),MONTH(A15)-1,14),7)/7)