Formula Help with Count of Week Numbers for every Each Month

[Lukma]

Hi Friend

Good day all, I need help with a formula on the week number in my data Column C and I need it to count for each month and for the following month to start all over counting from 1-5
I am having doubts about the formula I have used.
Let's say January 2023 I want it to count the total week number for January including weekends and for the following to start from 1 and count again for February etc.

Appreciate Your help with a solution.

2023-Master Data Onshore Jetty Operation Tracking.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N
4	Month	Mus Num	Supply Vessel	Vessel Arrived FWB Date&Time	Chanel Status	Manifest Date & Time	Mnfst On Time	Mnfst Delay Hours	Control Tower Permission Date & Time	Tower Perm On Time	Tower Perms Delay Hours	Vessel Arrive ADNOC Port Date & Time
5	5	1153-M	ADNOC-230	27/04/23 14:25		27/04/23 14:30	00:05	Met	27/04/23 19:30	5:00	Not Met	27/04/23 23:35
6	1	1154	CECILIE-K	01/05/23 10:00		01/05/23 12:40	02:40	Met	01/05/23 12:44	0:04	Met	01/05/23 18:06
7	1	1155	Z-OCEAN	01/05/23 14:30		01/05/23 13:40	-00:50	Met	01/05/23 13:51	0:11	Met	01/05/23 18:10
8	1	1156	SWISSCO RUBY	02/05/23 06:00		01/05/23 21:56	-08:04	Met	01/05/23 22:40	0:44	Met	02/05/23 09:35
9	1	1157	LCT-SHEWELEH	01/05/23 16:00		01/05/23 17:37	01:37	Met	01/05/23 18:27	0:50	Met	01/05/23 23:05
10	1	1158	A-RANGER	01/05/23 20:00		01/05/23 16:57	-03:03	Met	01/05/23 17:00	0:03	Met	02/05/23 00:25
11	1	1159	ADNOC-S02	01/05/23 21:10		01/05/23 20:14	-00:56	Met	02/05/23 03:00	6:46	Not Met	02/05/23 03:00
12	1	1160	ADNOC-810	01/05/23 01:50		01/05/23 19:55	18:05	Not Met	01/05/23 20:08	0:13	Met	01/05/23 22:50
13	1	1161	ADNOC-511	01/05/23 22:10		01/05/23 21:21	-00:49	Met	01/05/23 21:38	0:17	Met	02/05/23 02:35
14	1	1162	SK MAINSTAY	02/05/23 06:05		02/05/23 01:59	-04:06	Met	02/05/23 05:46	3:47	Not Met	02/05/23 09:55
15	1	1163	MUTAWA-402	01/05/23 10:00		02/05/23 01:31	15:31	Not Met	02/05/23 01:50	0:19	Met	02/05/23 06:30
16	1	1164	ADNOC-512	02/05/23 08:10		02/05/23 05:19	-02:51	Met	02/05/23 05:50	0:31	Met	02/05/23 11:55
17	1	1165	ADNOC-812	02/05/23 09:40		02/05/23 09:13	-00:27	Met	02/05/23 09:22	0:09	Met	02/05/23 16:50
18	1	1166	Z-POWER	02/05/23 04:20		02/05/23 11:14	06:54	Not Met	02/05/23 11:49	0:35	Met	02/05/23 14:35
19	1	1167	ADNOC-811	02/05/23 09:55		02/05/23 11:01	01:06	Met	02/05/23 11:50	0:49	Met	02/05/23 15:30
20	1	1168	ADNOC-222	02/05/23 08:20		02/05/23 11:20	03:00	Not Met	02/05/23 11:49	0:29	Met	02/05/23 16:20
21	1	1169	SMIT LUMUT	02/05/23 18:00		02/05/23 13:26	-04:34	Met	02/05/23 20:10	6:44	Not Met	02/05/23 23:59
22	1	1170	A-RADIANT-7	02/05/23 09:00		02/05/23 13:08	04:08	Not Met	02/05/23 15:22	2:14	Met	02/05/23 20:10
Onshore Tracking Report

Cell Formulas
Range	Formula
I5:I22	I5	=IFERROR(IF((H5-F5)>0,(H5-F5),TEXT(ABS(H5-F5),"-hh:mm")),"")
J5:J22	J5	=IF(F5="","",IF(OR(LEFT(I5,1)="-",I5<3/24),"Met","Not Met"))
L5:L22	L5	=IFERROR(IF((K5-H5)>0,(K5-H5),TEXT(ABS(K5-H5),"-h:mm")),"")
M5:M22	M5	=IF(H5="","",IF(OR(LEFT(L5,1)="-",L5<3/24),"Met","Not Met"))
C5:C22	C5	=IF(WEEKDAY(N5,2)>7,"",WEEKNUM(N5)-WEEKNUM(DATE(YEAR(N5),MONTH(N5),1))+1)

 

[Phuoc]

Try change to:

=MIN(5,WEEKNUM(B340)-WEEKNUM(EOMONTH(B340,-1)+1)+1)

 

[Peter_SSs]

What about this?

23 08 20.xlsm
	A	B
2	Week Number	Date & Time
3	1	01/01/23 12:00
4	1	01/01/23 14:35
5	1	01/01/23 18:10
6	1	01/01/23 17:45
7	1	01/01/23 18:05
8	1	01/01/23 18:15
9	1	02/01/23 01:40
10	1	02/01/23 20:00
11	1	02/01/23 19:15
12	1	02/01/23 22:30
13	1	03/01/23 14:50
14	1	03/01/23 21:24
15	1	04/01/23 16:45
16	1	03/01/23 13:20
17	1	04/01/23 00:50
18	1	04/01/23 00:40
19	1	04/01/23 00:20
20	1	03/01/23 23:20
21	1	04/01/23 03:30
22	1	03/01/23 23:40
23	1	04/01/23 12:30
24	1	04/01/23 08:10
25	1	05/01/23 04:35
26	1	04/01/23 17:30
27	1	04/01/23 19:00
28	1	04/01/23 20:00
29	1	05/01/23 11:00
30	1	05/01/23 04:35
31	1	05/01/23 14:05
32	1	05/01/23 14:40
33	1	05/01/23 16:48
34	1	05/01/23 23:00
35	1	06/01/23 00:20
36	1	05/01/23 22:10
37	1	06/01/23 00:50
38	1	06/01/23 04:40
39	1	06/01/23 23:30
40	1	07/01/23 03:30
41	1	07/01/23 00:10
42	1	07/01/23 02:00
43	2	08/01/23 06:35
44	2	08/01/23 06:30
45	2	08/01/23 07:10
46	2	08/01/23 10:45
47	2	08/01/23 16:45
48	2	08/01/23 10:00
49	2	08/01/23 19:53
50	2	08/01/23 21:27
51	2	08/01/23 17:45
52	2	08/01/23 17:12
53	2	08/01/23 21:10
54	2	08/01/23 17:20
55	2	09/01/23 08:30
56	2	09/01/23 03:00
57	2	09/01/23 06:54
58	2	09/01/23 03:15
59	2	09/01/23 04:00
60	2	09/01/23 05:25
61	2	09/01/23 09:50
62	2	08/01/23 23:50
63	2	09/01/23 12:15
64	2	10/01/23 09:05
65	2	09/01/23 17:20
66	2	09/01/23 14:00
67	2	09/01/23 21:00
68	2	09/01/23 23:50
69	2	10/01/23 14:45
70	2	10/01/23 14:30
71	2	10/01/23 15:15
72	2	10/01/23 23:05
73	2	10/01/23 19:55
74	2	10/01/23 20:00
75	2	11/01/23 02:05
76	2	10/01/23 22:10
77	2	10/01/23 21:20
78	2	10/01/23 22:15
79	2	10/01/23 23:59
80	2	11/01/23 00:45
81	1	05/01/23 13:10
82	2	10/01/23 21:45
83	2	11/01/23 04:25
84	2	11/01/23 13:35
85	2	12/01/23 04:10
86	2	11/01/23 20:50
87	2	11/01/23 20:35
88	2	12/01/23 09:55
89	2	12/01/23 13:40
90	2	13/01/23 01:00
91	2	12/01/23 12:00
92	2	12/01/23 13:10
93	2	12/01/23 12:30
94	2	12/01/23 16:45
95	2	12/01/23 16:25
96	2	12/01/23 16:30
97	2	12/01/23 16:55
98	2	12/01/23 21:20
99	2	11/01/23 21:05
100	2	12/01/23 22:05
101	2	12/01/23 22:30
102	2	13/01/23 10:12
103	2	13/01/23 05:30
104	2	13/01/23 04:40
105	2	13/01/23 09:40
106	2	13/01/23 14:35
107	2	13/01/23 16:30
108	2	13/01/23 19:12
109	2	13/01/23 18:12
110	2	13/01/23 19:40
111	2	14/01/23 03:15
112	2	14/01/23 06:30
113	2	14/01/23 09:00
114	2	14/01/23 00:40
115	2	14/01/23 15:05
116	2	14/01/23 14:15
117	2	14/01/23 13:50
118	2	14/01/23 21:25
119	3	15/01/23 00:35
120	2	14/01/23 23:59
121	3	15/01/23 03:25
122	2	14/01/23 21:20
123	2	14/01/23 07:30
124	3	15/01/23 02:42
125	3	15/01/23 01:40
126	3	15/01/23 02:54
127	3	15/01/23 02:40
128	3	15/01/23 11:50
129	3	15/01/23 10:00
130	3	15/01/23 15:45
131	3	15/01/23 12:36
132	3	15/01/23 23:00
133	3	16/01/23 21:00
134	3	16/01/23 21:05
135	3	16/01/23 19:50
136	3	16/01/23 21:30
137	3	17/01/23 00:45
138	3	16/01/23 07:25
139	3	17/01/23 11:35
140	3	18/01/23 02:20
141	3	17/01/23 15:36
142	3	17/01/23 23:35
143	3	17/01/23 21:25
144	3	18/01/23 03:26
145	3	16/01/23 22:25
146	3	18/01/23 04:45
147	3	18/01/23 05:10
148	3	18/01/23 11:50
149	3	18/01/23 00:07
150	3	18/01/23 05:00
151	3	18/01/23 15:45
152	3	18/01/23 15:35
153	3	18/01/23 13:50
154	3	18/01/23 17:30
155	3	18/01/23 17:30
156	3	18/01/23 20:20
157	3	19/01/23 01:30
158	3	19/01/23 03:10
159	3	19/01/23 01:30
160	3	19/01/23 02:30
161	3	19/01/23 07:36
162	3	19/01/23 19:00
163	3	20/01/23 00:15
164	3	20/01/23 04:55
165	3	20/01/23 06:10
166	3	19/01/23 22:40
167	3	20/01/23 00:50
168	3	20/01/23 08:00
169	3	20/01/23 14:25
170	3	20/01/23 02:06
171	3	21/01/23 02:00
172	3	21/01/23 01:25
173	3	21/01/23 00:54
174	3	21/01/23 01:05
175	4	22/01/23 11:25
176	3	21/01/23 02:55
177	4	23/01/23 05:10
178	4	23/01/23 05:00
179	4	23/01/23 09:00
180	4	23/01/23 13:10
181	4	24/01/23 09:40
182	4	24/01/23 00:55
183	4	24/01/23 03:18
184	4	24/01/23 02:05
185	4	23/01/23 23:00
186	4	24/01/23 03:40
187	4	23/01/23 23:25
188	4	24/01/23 03:50
189	4	24/01/23 09:30
190	4	24/01/23 19:00
191	4	24/01/23 20:45
192	4	24/01/23 20:05
193	4	24/01/23 23:10
194	4	25/01/23 00:15
195	4	25/01/23 01:45
196	4	25/01/23 08:15
197	4	25/01/23 08:35
198	4	25/01/23 09:30
199	4	25/01/23 12:30
200	4	25/01/23 16:54
201	4	25/01/23 21:40
202	4	25/01/23 22:15
203	4	26/01/23 00:00
204	4	26/01/23 04:30
205	4	26/01/23 12:54
206	4	26/01/23 08:30
207	4	26/01/23 09:25
208	4	26/01/23 15:15
209	4	26/01/23 17:55
210	4	26/01/23 15:45
211	4	26/01/23 20:35
212	4	27/01/23 03:15
213	4	27/01/23 14:20
214	4	27/01/23 00:01
215	4	27/01/23 16:05
216	4	27/01/23 13:05
217	4	27/01/23 07:15
218	4	27/01/23 07:00
219	4	27/01/23 06:15
220	4	27/01/23 12:40
221	4	27/01/23 15:00
222	4	27/01/23 23:35
223	4	27/01/23 21:41
224	4	28/01/23 06:35
225	4	28/01/23 02:20
226	4	27/01/23 21:48
227	4	26/01/23 12:54
228	4	28/01/23 07:35
229	4	28/01/23 00:50
230	4	28/01/23 10:00
231	5	29/01/23 07:25
232	4	28/01/23 09:50
233	4	28/01/23 09:20
234	4	28/01/23 14:00
235	4	28/01/23 17:40
236	5	29/01/23 00:55
237	4	28/01/23 17:20
238	4	28/01/23 19:40
239	5	29/01/23 05:00
240	5	29/01/23 11:10
241	5	29/01/23 05:15
242	5	29/01/23 07:30
243	5	29/01/23 09:54
244	5	29/01/23 06:45
245	5	29/01/23 20:15
246	5	30/01/23 07:10
247	5	30/01/23 00:40
248	5	30/01/23 05:35
249	5	30/01/23 16:15
250	5	30/01/23 23:30
251	5	30/01/23 20:40
252	5	30/01/23 18:10
253	5	31/01/23 15:50
254	5	31/01/23 06:30
255	5	31/01/23 10:30
256	5	31/01/23 23:00
257	5	31/01/23 22:25
258	5	31/01/23 22:20
259	1	01/02/23 02:35
260	1	01/02/23 02:15
261	1	01/02/23 05:00
262	1	01/02/23 12:45
263	1	01/02/23 17:15
264	1	01/02/23 17:50
265	1	01/02/23 23:15
266	1	02/02/23 12:10
267	1	02/02/23 06:20
268	1	01/02/23 22:45
269	1	02/02/23 11:06
270	1	02/02/23 09:00
271	1	02/02/23 14:30
272	1	02/02/23 15:10
273	1	02/02/23 15:00
274	1	02/02/23 18:35
275	1	02/02/23 23:00
276	1	02/02/23 08:35
277	1	03/02/23 06:55
278	1	03/02/23 01:45
279	1	03/02/23 08:20
280	1	03/02/23 01:00
281	1	02/02/23 23:36
282	1	03/02/23 09:00
283	1	04/02/23 03:35
284	1	04/02/23 04:00
285	1	04/02/23 03:30
286	1	04/02/23 07:15
287	1	04/02/23 01:15
288	1	04/02/23 05:15
289	1	04/02/23 06:15
290	1	04/02/23 14:55
291	1	04/02/23 19:18
292	1	04/02/23 22:50
293	1	05/02/23 00:45
294	1	05/02/23 03:00
295	1	05/02/23 17:36
296	1	05/02/23 15:35
297	1	05/02/23 05:20
298	1	05/02/23 05:35
299	1	05/02/23 03:45
300	1	05/02/23 16:15
301	1	05/02/23 17:20
302	1	06/02/23 02:00
303	1	05/02/23 21:05
304	1	05/02/23 22:45
305	1	06/02/23 06:40
306	1	06/02/23 04:25
307	1	05/02/23 00:45
308	1	06/02/23 06:35
309	1	06/02/23 00:15
310	1	06/02/23 03:50
311	1	05/02/23 23:06
312	1	06/02/23 02:10
313	1	07/02/23 07:45
314	1	07/02/23 12:10
315	1	07/02/23 13:20
316	1	07/02/23 18:00
317	1	07/02/23 18:35
318	1	07/02/23 13:20
319	2	08/02/23 00:40
320	2	08/02/23 18:25
321	2	09/02/23 19:54
322	2	10/02/23 01:30
323	2	10/02/23 00:30
324	2	09/02/23 08:48
325	2	10/02/23 04:50
326	2	10/02/23 04:00
327	2	10/02/23 09:20
328	2	10/02/23 15:25
329	2	10/02/23 18:50
330	2	10/02/23 20:22
331	2	11/02/23 03:10
332	2	11/02/23 11:10
333	2	11/02/23 02:20
334	2	11/02/23 07:30
335	2	11/02/23 09:10
336	2	11/02/23 16:30
337	2	11/02/23 16:45
338
339	5	29/07/23 08:30
340	5	29/07/23 13:30
341	5	29/07/23 13:25
342	5	29/07/23 15:05
343	5	29/07/23 15:45
344	5	30/07/23 02:30
345	5	29/07/23 17:00
346	5	30/07/23 04:10
347	5	29/07/23 18:15
348	5	30/07/23 02:10
349	5	30/07/23 04:30
350	5	30/07/23 05:50
351	5	30/07/23 11:35
352	5	30/07/23 12:15
353	5	30/07/23 02:45
354	5	29/07/23 22:35
355	5	29/07/23 22:45
356	5	30/07/23 13:30
357	5	30/07/23 09:06
358	5	30/07/23 21:30
359	5	30/07/23 22:55
360	5	30/07/23 13:30
361	5	30/07/23 22:35
362	5	31/07/23 00:45
363	5	31/07/23 10:25
364	5	31/07/23 07:40
365	5	31/07/23 12:35
366	5	31/07/23 01:40
367	5	31/07/23 10:53
368	5	31/07/23 07:40
369	5	31/07/23 07:05
370	5	31/07/23 16:35
371	5	31/07/23 17:12
372	5	31/07/23 21:40
Wk (2)

Cell Formulas
Range	Formula
A3:A337,A339:A372	A3	=MATCH(DAY(B3),{1,8,15,22,29})

 

[Anonymous1378]

Hi

Thank you so much, I tried it but when it comes to July month am having some problems, Close to the month's end is giving Wk-6 rather than 5weeks number is they am i missing out

That the result after dragging it down

Appreciate your support

2023-Master Data Onshore Jetty Operation Tracking.xlsx
	A	B
340	5	29/07/23 08:30
341	5	29/07/23 13:30
342	5	29/07/23 13:25
343	5	29/07/23 15:05
344	5	29/07/23 15:45
345	6	30/07/23 02:30
346	5	29/07/23 17:00
347	6	30/07/23 04:10
348	5	29/07/23 18:15
349	6	30/07/23 02:10
350	6	30/07/23 04:30
351	6	30/07/23 05:50
352	6	30/07/23 11:35
353	6	30/07/23 12:15
354	6	30/07/23 02:45
355	5	29/07/23 22:35
356	5	29/07/23 22:45
357	6	30/07/23 13:30
358	6	30/07/23 09:06
359	6	30/07/23 21:30
360	6	30/07/23 22:55
361	6	30/07/23 13:30
362	6	30/07/23 22:35
363	6	31/07/23 00:45
364	6	31/07/23 10:25
365	6	31/07/23 07:40
366	6	31/07/23 12:35
367	6	31/07/23 01:40
368	6	31/07/23 10:53
369	6	31/07/23 07:40
370	6	31/07/23 07:05
371	6	31/07/23 16:35
372	6	31/07/23 17:12
373	6	31/07/23 21:40
Sheet4

Cell Formulas
Range	Formula
A340:A373	A340	=MATCH(WEEKNUM(B340),ROW(INDIRECT(WEEKNUM(EOMONTH(B340,-1)+1)&":"&WEEKNUM(EOMONTH(B340,0)))))

That's because there is a sixth week in July. 30 and 31 on the sixth row are considered week 6. Do you want to just cap it at 5?

 

[Lukma]

That's because there is a sixth week in July. 30 and 31 on the sixth row are considered week 6. Do you want to just cap it at 5?

View attachment 97473

Thanks Anony

Yes that will be great if i can capture it as 5

i really appreciate your support with it

regards

 

[Lukma]

What about this?

23 08 20.xlsm
	A	B
2	Week Number	Date & Time
3	1	01/01/23 12:00
4	1	01/01/23 14:35
5	1	01/01/23 18:10
6	1	01/01/23 17:45
7	1	01/01/23 18:05
8	1	01/01/23 18:15
9	1	02/01/23 01:40
10	1	02/01/23 20:00
11	1	02/01/23 19:15
12	1	02/01/23 22:30
13	1	03/01/23 14:50
14	1	03/01/23 21:24
15	1	04/01/23 16:45
16	1	03/01/23 13:20
17	1	04/01/23 00:50
18	1	04/01/23 00:40
19	1	04/01/23 00:20
20	1	03/01/23 23:20
21	1	04/01/23 03:30
22	1	03/01/23 23:40
23	1	04/01/23 12:30
24	1	04/01/23 08:10
25	1	05/01/23 04:35
26	1	04/01/23 17:30
27	1	04/01/23 19:00
28	1	04/01/23 20:00
29	1	05/01/23 11:00
30	1	05/01/23 04:35
31	1	05/01/23 14:05
32	1	05/01/23 14:40
33	1	05/01/23 16:48
34	1	05/01/23 23:00
35	1	06/01/23 00:20
36	1	05/01/23 22:10
37	1	06/01/23 00:50
38	1	06/01/23 04:40
39	1	06/01/23 23:30
40	1	07/01/23 03:30
41	1	07/01/23 00:10
42	1	07/01/23 02:00
43	2	08/01/23 06:35
44	2	08/01/23 06:30
45	2	08/01/23 07:10
46	2	08/01/23 10:45
47	2	08/01/23 16:45
48	2	08/01/23 10:00
49	2	08/01/23 19:53
50	2	08/01/23 21:27
51	2	08/01/23 17:45
52	2	08/01/23 17:12
53	2	08/01/23 21:10
54	2	08/01/23 17:20
55	2	09/01/23 08:30
56	2	09/01/23 03:00
57	2	09/01/23 06:54
58	2	09/01/23 03:15
59	2	09/01/23 04:00
60	2	09/01/23 05:25
61	2	09/01/23 09:50
62	2	08/01/23 23:50
63	2	09/01/23 12:15
64	2	10/01/23 09:05
65	2	09/01/23 17:20
66	2	09/01/23 14:00
67	2	09/01/23 21:00
68	2	09/01/23 23:50
69	2	10/01/23 14:45
70	2	10/01/23 14:30
71	2	10/01/23 15:15
72	2	10/01/23 23:05
73	2	10/01/23 19:55
74	2	10/01/23 20:00
75	2	11/01/23 02:05
76	2	10/01/23 22:10
77	2	10/01/23 21:20
78	2	10/01/23 22:15
79	2	10/01/23 23:59
80	2	11/01/23 00:45
81	1	05/01/23 13:10
82	2	10/01/23 21:45
83	2	11/01/23 04:25
84	2	11/01/23 13:35
85	2	12/01/23 04:10
86	2	11/01/23 20:50
87	2	11/01/23 20:35
88	2	12/01/23 09:55
89	2	12/01/23 13:40
90	2	13/01/23 01:00
91	2	12/01/23 12:00
92	2	12/01/23 13:10
93	2	12/01/23 12:30
94	2	12/01/23 16:45
95	2	12/01/23 16:25
96	2	12/01/23 16:30
97	2	12/01/23 16:55
98	2	12/01/23 21:20
99	2	11/01/23 21:05
100	2	12/01/23 22:05
101	2	12/01/23 22:30
102	2	13/01/23 10:12
103	2	13/01/23 05:30
104	2	13/01/23 04:40
105	2	13/01/23 09:40
106	2	13/01/23 14:35
107	2	13/01/23 16:30
108	2	13/01/23 19:12
109	2	13/01/23 18:12
110	2	13/01/23 19:40
111	2	14/01/23 03:15
112	2	14/01/23 06:30
113	2	14/01/23 09:00
114	2	14/01/23 00:40
115	2	14/01/23 15:05
116	2	14/01/23 14:15
117	2	14/01/23 13:50
118	2	14/01/23 21:25
119	3	15/01/23 00:35
120	2	14/01/23 23:59
121	3	15/01/23 03:25
122	2	14/01/23 21:20
123	2	14/01/23 07:30
124	3	15/01/23 02:42
125	3	15/01/23 01:40
126	3	15/01/23 02:54
127	3	15/01/23 02:40
128	3	15/01/23 11:50
129	3	15/01/23 10:00
130	3	15/01/23 15:45
131	3	15/01/23 12:36
132	3	15/01/23 23:00
133	3	16/01/23 21:00
134	3	16/01/23 21:05
135	3	16/01/23 19:50
136	3	16/01/23 21:30
137	3	17/01/23 00:45
138	3	16/01/23 07:25
139	3	17/01/23 11:35
140	3	18/01/23 02:20
141	3	17/01/23 15:36
142	3	17/01/23 23:35
143	3	17/01/23 21:25
144	3	18/01/23 03:26
145	3	16/01/23 22:25
146	3	18/01/23 04:45
147	3	18/01/23 05:10
148	3	18/01/23 11:50
149	3	18/01/23 00:07
150	3	18/01/23 05:00
151	3	18/01/23 15:45
152	3	18/01/23 15:35
153	3	18/01/23 13:50
154	3	18/01/23 17:30
155	3	18/01/23 17:30
156	3	18/01/23 20:20
157	3	19/01/23 01:30
158	3	19/01/23 03:10
159	3	19/01/23 01:30
160	3	19/01/23 02:30
161	3	19/01/23 07:36
162	3	19/01/23 19:00
163	3	20/01/23 00:15
164	3	20/01/23 04:55
165	3	20/01/23 06:10
166	3	19/01/23 22:40
167	3	20/01/23 00:50
168	3	20/01/23 08:00
169	3	20/01/23 14:25
170	3	20/01/23 02:06
171	3	21/01/23 02:00
172	3	21/01/23 01:25
173	3	21/01/23 00:54
174	3	21/01/23 01:05
175	4	22/01/23 11:25
176	3	21/01/23 02:55
177	4	23/01/23 05:10
178	4	23/01/23 05:00
179	4	23/01/23 09:00
180	4	23/01/23 13:10
181	4	24/01/23 09:40
182	4	24/01/23 00:55
183	4	24/01/23 03:18
184	4	24/01/23 02:05
185	4	23/01/23 23:00
186	4	24/01/23 03:40
187	4	23/01/23 23:25
188	4	24/01/23 03:50
189	4	24/01/23 09:30
190	4	24/01/23 19:00
191	4	24/01/23 20:45
192	4	24/01/23 20:05
193	4	24/01/23 23:10
194	4	25/01/23 00:15
195	4	25/01/23 01:45
196	4	25/01/23 08:15
197	4	25/01/23 08:35
198	4	25/01/23 09:30
199	4	25/01/23 12:30
200	4	25/01/23 16:54
201	4	25/01/23 21:40
202	4	25/01/23 22:15
203	4	26/01/23 00:00
204	4	26/01/23 04:30
205	4	26/01/23 12:54
206	4	26/01/23 08:30
207	4	26/01/23 09:25
208	4	26/01/23 15:15
209	4	26/01/23 17:55
210	4	26/01/23 15:45
211	4	26/01/23 20:35
212	4	27/01/23 03:15
213	4	27/01/23 14:20
214	4	27/01/23 00:01
215	4	27/01/23 16:05
216	4	27/01/23 13:05
217	4	27/01/23 07:15
218	4	27/01/23 07:00
219	4	27/01/23 06:15
220	4	27/01/23 12:40
221	4	27/01/23 15:00
222	4	27/01/23 23:35
223	4	27/01/23 21:41
224	4	28/01/23 06:35
225	4	28/01/23 02:20
226	4	27/01/23 21:48
227	4	26/01/23 12:54
228	4	28/01/23 07:35
229	4	28/01/23 00:50
230	4	28/01/23 10:00
231	5	29/01/23 07:25
232	4	28/01/23 09:50
233	4	28/01/23 09:20
234	4	28/01/23 14:00
235	4	28/01/23 17:40
236	5	29/01/23 00:55
237	4	28/01/23 17:20
238	4	28/01/23 19:40
239	5	29/01/23 05:00
240	5	29/01/23 11:10
241	5	29/01/23 05:15
242	5	29/01/23 07:30
243	5	29/01/23 09:54
244	5	29/01/23 06:45
245	5	29/01/23 20:15
246	5	30/01/23 07:10
247	5	30/01/23 00:40
248	5	30/01/23 05:35
249	5	30/01/23 16:15
250	5	30/01/23 23:30
251	5	30/01/23 20:40
252	5	30/01/23 18:10
253	5	31/01/23 15:50
254	5	31/01/23 06:30
255	5	31/01/23 10:30
256	5	31/01/23 23:00
257	5	31/01/23 22:25
258	5	31/01/23 22:20
259	1	01/02/23 02:35
260	1	01/02/23 02:15
261	1	01/02/23 05:00
262	1	01/02/23 12:45
263	1	01/02/23 17:15
264	1	01/02/23 17:50
265	1	01/02/23 23:15
266	1	02/02/23 12:10
267	1	02/02/23 06:20
268	1	01/02/23 22:45
269	1	02/02/23 11:06
270	1	02/02/23 09:00
271	1	02/02/23 14:30
272	1	02/02/23 15:10
273	1	02/02/23 15:00
274	1	02/02/23 18:35
275	1	02/02/23 23:00
276	1	02/02/23 08:35
277	1	03/02/23 06:55
278	1	03/02/23 01:45
279	1	03/02/23 08:20
280	1	03/02/23 01:00
281	1	02/02/23 23:36
282	1	03/02/23 09:00
283	1	04/02/23 03:35
284	1	04/02/23 04:00
285	1	04/02/23 03:30
286	1	04/02/23 07:15
287	1	04/02/23 01:15
288	1	04/02/23 05:15
289	1	04/02/23 06:15
290	1	04/02/23 14:55
291	1	04/02/23 19:18
292	1	04/02/23 22:50
293	1	05/02/23 00:45
294	1	05/02/23 03:00
295	1	05/02/23 17:36
296	1	05/02/23 15:35
297	1	05/02/23 05:20
298	1	05/02/23 05:35
299	1	05/02/23 03:45
300	1	05/02/23 16:15
301	1	05/02/23 17:20
302	1	06/02/23 02:00
303	1	05/02/23 21:05
304	1	05/02/23 22:45
305	1	06/02/23 06:40
306	1	06/02/23 04:25
307	1	05/02/23 00:45
308	1	06/02/23 06:35
309	1	06/02/23 00:15
310	1	06/02/23 03:50
311	1	05/02/23 23:06
312	1	06/02/23 02:10
313	1	07/02/23 07:45
314	1	07/02/23 12:10
315	1	07/02/23 13:20
316	1	07/02/23 18:00
317	1	07/02/23 18:35
318	1	07/02/23 13:20
319	2	08/02/23 00:40
320	2	08/02/23 18:25
321	2	09/02/23 19:54
322	2	10/02/23 01:30
323	2	10/02/23 00:30
324	2	09/02/23 08:48
325	2	10/02/23 04:50
326	2	10/02/23 04:00
327	2	10/02/23 09:20
328	2	10/02/23 15:25
329	2	10/02/23 18:50
330	2	10/02/23 20:22
331	2	11/02/23 03:10
332	2	11/02/23 11:10
333	2	11/02/23 02:20
334	2	11/02/23 07:30
335	2	11/02/23 09:10
336	2	11/02/23 16:30
337	2	11/02/23 16:45
338
339	5	29/07/23 08:30
340	5	29/07/23 13:30
341	5	29/07/23 13:25
342	5	29/07/23 15:05
343	5	29/07/23 15:45
344	5	30/07/23 02:30
345	5	29/07/23 17:00
346	5	30/07/23 04:10
347	5	29/07/23 18:15
348	5	30/07/23 02:10
349	5	30/07/23 04:30
350	5	30/07/23 05:50
351	5	30/07/23 11:35
352	5	30/07/23 12:15
353	5	30/07/23 02:45
354	5	29/07/23 22:35
355	5	29/07/23 22:45
356	5	30/07/23 13:30
357	5	30/07/23 09:06
358	5	30/07/23 21:30
359	5	30/07/23 22:55
360	5	30/07/23 13:30
361	5	30/07/23 22:35
362	5	31/07/23 00:45
363	5	31/07/23 10:25
364	5	31/07/23 07:40
365	5	31/07/23 12:35
366	5	31/07/23 01:40
367	5	31/07/23 10:53
368	5	31/07/23 07:40
369	5	31/07/23 07:05
370	5	31/07/23 16:35
371	5	31/07/23 17:12
372	5	31/07/23 21:40
Wk (2)

Cell Formulas
Range	Formula
A3:A337,A339:A372	A3	=MATCH(DAY(B3),{1,8,15,22,29})

Hi peter

It's been a great day hearing from and assisting as usual it works just fine and many thanks

 

[Lukma]

Try change to:

=MIN(5,WEEKNUM(B340)-WEEKNUM(EOMONTH(B340,-1)+1)+1)

Thank Phuoc

It's great and perfectly works just as I needed it however can I apply it to all
your all are great and helpful

i appreciate everyone

Thanks

 

[Peter_SSs]

Hi peter

It's been a great day hearing from and assisting as usual it works just fine and many thanks

You're welcome. Thanks for the follow-up.

 

[Armstrong_N14]

Cell Formulas
Range	Formula
A2	=SEQUENCE(365,1,DATE(2023,1,1),1)
B2 then Drag til B366	=IF(AND(TEXT(VALUE(EOMONTH(A2,-1)+1),"mm")=TEXT(VALUE($A2),"mm"),TEXT(VALUE($A2),"dd")+6<14),1,IF(AND(TEXT(VALUE(EOMONTH(A2,-1)+1),"mm")=TEXT(VALUE($A2),"mm"),TEXT(VALUE($A2),"dd")+6<21),2,IF(AND(TEXT(VALUE(EOMONTH(A2,-1)+1),"mm")=TEXT(VALUE($A2),"mm"),TEXT(VALUE($A2),"dd")+6<28),3,IF(AND(TEXT(VALUE(EOMONTH(A2,-1)+1),"mm")=TEXT(VALUE($A2),"mm"),TEXT(VALUE($A2),"dd")+6<35),4,IF(AND(TEXT(VALUE(EOMONTH(A2,-1)+1),"mm")=TEXT(VALUE($A2),"mm"),TEXT(VALUE($A2),"dd")+6<37),5,B1)))))

 

[Peter_SSs]

@Armstrong_N14
Wondering if you tested the short suggestions made earlier before developing that huge formula to do the same job?

Also please be careful not to duplicate posts. I have removed the duplicate.

 

[Armstrong_N14]

@Armstrong_N14
Wondering if you tested the short suggestions made earlier before developing that huge formula to do the same job?

Also please be careful not to duplicate posts. I have removed the duplicate.

I was so silly not to see the resolved tag Apologies. And I got net issues causing my post to get duplicated.