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)

 

[Fluff]

You can remove the IF function as WEEKDAY(N5,2)>7 will always return False.
Other than that what is wrong with your formula?

 

[Lukma]

You can remove the IF function as WEEKDAY(N5,2)>7 will always return False.
Other than that what is wrong with your formula?

Hi Fluff

Sorry for the late reply and thanks for your feedback, actually the formula I required for the week's Number count is for each month

Let's say January 2023 I need the formula for week number to be every 7 days counted as week 1, 2 , 3, 4 till the end of the month then when it comes to next following month it should start again from week 1 for February

I hope I am able to explain what I need from the data with the weekly number for each month

regards

2023-Master Data Onshore Jetty Operation Tracking.xlsx
	C	D
2	Week Number	Date & Time
3	Wk 1	01/01/2023
4	Wk 1	02/01/2023
5	Wk 1	03/01/2023
6	Wk 1	04/01/2023
7	Wk 1	05/01/2023
8	Wk 1	06/01/2023
9	Wk 1	07/01/2023
10	Wk 2	08/01/2023
11	Wk 2	09/01/2023
12	Wk 2	10/01/2023
13	Wk 2	11/01/2023
14	Wk 2	12/01/2023
15	Wk 2	13/01/2023
16	Wk 2	14/01/2023
17	Wk 3	15/01/2023
18	Wk 3	16/01/2023
19	Wk 3	17/01/2023
20	Wk 3	18/01/2023
21	Wk 3	19/01/2023
22	Wk 3	20/01/2023
23	Wk 3	21/01/2023
24	Wk 4	22/01/2023
25	Wk 4	23/01/2023
26	Wk 4	24/01/2023
27	Wk 4	25/01/2023
28	Wk 4	26/01/2023
29	Wk 4	27/01/2023
30	Wk 4	28/01/2023
31	Wk 4	29/01/2023
32	Wk 4	30/01/2023
33	Wk 4	31/01/2023
34	Wk 1	01/02/2023
35	Wk 1	02/02/2023
36	Wk 1	03/02/2023
37	Wk 1	04/02/2023
38	Wk 1	05/02/2023
39	Wk 1	06/02/2023
40	Wk 1	07/02/2023
41	Wk 2	08/02/2023
42	Wk 2	09/02/2023
43	Wk 2	10/02/2023
44	Wk 2	11/02/2023
45	Wk 2	12/02/2023
46	Wk 2	13/02/2023
47	Wk 2	14/02/2023
48	Wk 3	15/02/2023
49	Wk 3	16/02/2023
50	Wk 3	17/02/2023
51	Wk 3	18/02/2023
52	Wk 3	19/02/2023
53	Wk 3	20/02/2023
54	Wk 3	21/02/2023
55	Wk 4	22/02/2023
56	Wk 4	23/02/2023
57	Wk 4	24/02/2023
58	Wk 4	25/02/2023
59	Wk 4	26/02/2023
60	Wk 4	27/02/2023
61	Wk 4	28/02/2023
Sheet3

 

[Peter_SSs]

Does your mini sheet show what you want?
If so, why does January Wk 4 have 10 days in it?

If your mini sheet is not what you want, please post again with what you do want.

 

[Lukma]

Hi friends

Good day to you all, am having trouble with the week number, my date & time format in my data & time starts from January 1st, 2023

So what I need the formula to do for each month is to count every 7 days as Wk-1then next 7 days will be wk-2 because the operation runs nonstop for all month including the weekends
so when it comes to the following month then to start from Wk-1 again.

I hope am able to explain, in my table what i need the formula to do for each month's week number, please if there is a better formula to do this I will appreciate it from you all

regards

2023-Master Data Onshore Jetty Operation Tracking.xlsx
	G	H
2	Week Number	Date & Time
3	Wk 1	01/01/23 12:00
4	Wk 1	01/01/23 14:35
5	Wk 1	01/01/23 18:10
6	Wk 1	01/01/23 17:45
7	Wk 1	01/01/23 18:05
8	Wk 1	01/01/23 18:15
9	Wk 1	02/01/23 01:40
10	Wk 1	02/01/23 20:00
11	Wk 1	02/01/23 19:15
12	Wk 1	02/01/23 22:30
13	Wk 1	03/01/23 14:50
14	Wk 1	03/01/23 21:24
15	Wk 1	04/01/23 16:45
16	Wk 1	03/01/23 13:20
17	Wk 1	04/01/23 00:50
18	Wk 1	04/01/23 00:40
19	Wk 1	04/01/23 00:20
20	Wk 1	03/01/23 23:20
21	Wk 1	04/01/23 03:30
22	Wk 1	03/01/23 23:40
23	Wk 1	04/01/23 12:30
24	Wk 1	04/01/23 08:10
25	Wk 1	05/01/23 04:35
26	Wk 1	04/01/23 17:30
27	Wk 1	04/01/23 19:00
28	Wk 1	04/01/23 20:00
29	Wk 1	05/01/23 11:00
30	Wk 1	05/01/23 04:35
31	Wk 1	05/01/23 14:05
32	Wk 1	05/01/23 14:40
33	Wk 1	05/01/23 16:48
34	Wk 1	05/01/23 23:00
35	Wk 1	06/01/23 00:20
36	Wk 1	05/01/23 22:10
37	Wk 1	06/01/23 00:50
38	Wk 1	06/01/23 04:40
39	Wk 1	06/01/23 23:30
40	Wk 1	07/01/23 03:30
41	Wk 1	07/01/23 00:10
42	Wk 1	07/01/23 02:00
43	Wk 2	08/01/23 06:35
44	Wk 2	08/01/23 06:30
45	Wk 2	08/01/23 07:10
46	Wk 2	08/01/23 10:45
47	Wk 2	08/01/23 16:45
48	Wk 2	08/01/23 10:00
49	Wk 2	08/01/23 19:53
50	Wk 2	08/01/23 21:27
51	Wk 2	08/01/23 17:45
52	Wk 2	08/01/23 17:12
53	Wk 2	08/01/23 21:10
54	Wk 2	08/01/23 17:20
55	Wk 2	09/01/23 08:30
56	Wk 2	09/01/23 03:00
57	Wk 2	09/01/23 06:54
58	Wk 2	09/01/23 03:15
59	Wk 2	09/01/23 04:00
60	Wk 2	09/01/23 05:25
61	Wk 2	09/01/23 09:50
62	Wk 2	08/01/23 23:50
63	Wk 2	09/01/23 12:15
64	Wk 2	10/01/23 09:05
65	Wk 2	09/01/23 17:20
66	Wk 2	09/01/23 14:00
67	Wk 2	09/01/23 21:00
68	Wk 2	09/01/23 23:50
69	Wk 2	10/01/23 14:45
70	Wk 2	10/01/23 14:30
71	Wk 2	10/01/23 15:15
72	Wk 2	10/01/23 23:05
73	Wk 2	10/01/23 19:55
74	Wk 2	10/01/23 20:00
75	Wk 2	11/01/23 02:05
76	Wk 2	10/01/23 22:10
77	Wk 2	10/01/23 21:20
78	Wk 2	10/01/23 22:15
79	Wk 2	10/01/23 23:59
80	Wk 2	11/01/23 00:45
81	Wk 1	05/01/23 13:10
82	Wk 2	10/01/23 21:45
83	Wk 2	11/01/23 04:25
84	Wk 2	11/01/23 13:35
85	Wk 2	12/01/23 04:10
86	Wk 2	11/01/23 20:50
87	Wk 2	11/01/23 20:35
88	Wk 2	12/01/23 09:55
89	Wk 2	12/01/23 13:40
90	Wk 2	13/01/23 01:00
91	Wk 2	12/01/23 12:00
92	Wk 2	12/01/23 13:10
93	Wk 2	12/01/23 12:30
94	Wk 2	12/01/23 16:45
95	Wk 2	12/01/23 16:25
96	Wk 2	12/01/23 16:30
97	Wk 2	12/01/23 16:55
98	Wk 2	12/01/23 21:20
99	Wk 2	11/01/23 21:05
100	Wk 2	12/01/23 22:05
101	Wk 2	12/01/23 22:30
102	Wk 2	13/01/23 10:12
103	Wk 2	13/01/23 05:30
104	Wk 2	13/01/23 04:40
105	Wk 2	13/01/23 09:40
106	Wk 2	13/01/23 14:35
107	Wk 2	13/01/23 16:30
108	Wk 2	13/01/23 19:12
109	Wk 2	13/01/23 18:12
110	Wk 2	13/01/23 19:40
111	Wk 2	14/01/23 03:15
112	Wk 2	14/01/23 06:30
113	Wk 2	14/01/23 09:00
114	Wk 2	14/01/23 00:40
115	Wk 2	14/01/23 15:05
116	Wk 2	14/01/23 14:15
117	Wk 2	14/01/23 13:50
118	Wk 2	14/01/23 21:25
119	Wk 3	15/01/23 00:35
120	Wk 2	14/01/23 23:59
121	Wk 3	15/01/23 03:25
122	Wk 2	14/01/23 21:20
123	Wk 2	14/01/23 07:30
124	Wk 3	15/01/23 02:42
125	Wk 3	15/01/23 01:40
126	Wk 3	15/01/23 02:54
127	Wk 3	15/01/23 02:40
128	Wk 3	15/01/23 11:50
129	Wk 3	15/01/23 10:00
130	Wk 3	15/01/23 15:45
131	Wk 3	15/01/23 12:36
132	Wk 3	15/01/23 23:00
133	Wk 3	16/01/23 21:00
134	Wk 3	16/01/23 21:05
135	Wk 3	16/01/23 19:50
136	Wk 3	16/01/23 21:30
137	Wk 3	17/01/23 00:45
138	Wk 3	16/01/23 07:25
139	Wk 3	17/01/23 11:35
140	Wk 3	18/01/23 02:20
141	Wk 3	17/01/23 15:36
142	Wk 3	17/01/23 23:35
143	Wk 3	17/01/23 21:25
144	Wk 3	18/01/23 03:26
145	Wk 3	16/01/23 22:25
146	Wk 3	18/01/23 04:45
147	Wk 3	18/01/23 05:10
148	Wk 3	18/01/23 11:50
149	Wk 3	18/01/23 00:07
150	Wk 3	18/01/23 05:00
151	Wk 3	18/01/23 15:45
152	Wk 3	18/01/23 15:35
153	Wk 3	18/01/23 13:50
154	Wk 3	18/01/23 17:30
155	Wk 3	18/01/23 17:30
156	Wk 3	18/01/23 20:20
157	Wk 3	19/01/23 01:30
158	Wk 3	19/01/23 03:10
159	Wk 3	19/01/23 01:30
160	Wk 3	19/01/23 02:30
161	Wk 3	19/01/23 07:36
162	Wk 3	19/01/23 19:00
163	Wk 3	20/01/23 00:15
164	Wk 3	20/01/23 04:55
165	Wk 3	20/01/23 06:10
166	Wk 3	19/01/23 22:40
167	Wk 3	20/01/23 00:50
168	Wk 3	20/01/23 08:00
169	Wk 3	20/01/23 14:25
170	Wk 3	20/01/23 02:06
171	Wk 3	21/01/23 02:00
172	Wk 3	21/01/23 01:25
173	Wk 3	21/01/23 00:54
174	Wk 3	21/01/23 01:05
175	Wk 4	22/01/23 11:25
176	Wk 3	21/01/23 02:55
177	Wk 4	23/01/23 05:10
178	Wk 4	23/01/23 05:00
179	Wk 4	23/01/23 09:00
180	Wk 4	23/01/23 13:10
181	Wk 4	24/01/23 09:40
182	Wk 4	24/01/23 00:55
183	Wk 4	24/01/23 03:18
184	Wk 4	24/01/23 02:05
185	Wk 4	23/01/23 23:00
186	Wk 4	24/01/23 03:40
187	Wk 4	23/01/23 23:25
188	Wk 4	24/01/23 03:50
189	Wk 4	24/01/23 09:30
190	Wk 4	24/01/23 19:00
191	Wk 4	24/01/23 20:45
192	Wk 4	24/01/23 20:05
193	Wk 4	24/01/23 23:10
194	Wk 4	25/01/23 00:15
195	Wk 4	25/01/23 01:45
196	Wk 4	25/01/23 08:15
197	Wk 4	25/01/23 08:35
198	Wk 4	25/01/23 09:30
199	Wk 4	25/01/23 12:30
200	Wk 4	25/01/23 16:54
201	Wk 4	25/01/23 21:40
202	Wk 4	25/01/23 22:15
203	Wk 4	26/01/23 00:00
204	Wk 4	26/01/23 04:30
205	Wk 4	26/01/23 12:54
206	Wk 4	26/01/23 08:30
207	Wk 4	26/01/23 09:25
208	Wk 4	26/01/23 15:15
209	Wk 4	26/01/23 17:55
210	Wk 4	26/01/23 15:45
211	Wk 4	26/01/23 20:35
212	Wk 4	27/01/23 03:15
213	Wk 4	27/01/23 14:20
214	Wk 4	27/01/23 00:01
215	Wk 4	27/01/23 16:05
216	Wk 4	27/01/23 13:05
217	Wk 4	27/01/23 07:15
218	Wk 4	27/01/23 07:00
219	Wk 4	27/01/23 06:15
220	Wk 4	27/01/23 12:40
221	Wk 4	27/01/23 15:00
222	Wk 4	27/01/23 23:35
223	Wk 4	27/01/23 21:41
224	Wk 4	28/01/23 06:35
225	Wk 4	28/01/23 02:20
226	Wk 4	27/01/23 21:48
227	Wk 4	26/01/23 12:54
228	Wk 4	28/01/23 07:35
229	Wk 4	28/01/23 00:50
230	Wk 4	28/01/23 10:00
231	Wk 5	29/01/23 07:25
232	Wk 4	28/01/23 09:50
233	Wk 4	28/01/23 09:20
234	Wk 4	28/01/23 14:00
235	Wk 4	28/01/23 17:40
236	Wk 5	29/01/23 00:55
237	Wk 4	28/01/23 17:20
238	Wk 4	28/01/23 19:40
239	Wk 5	29/01/23 05:00
240	Wk 5	29/01/23 11:10
241	Wk 5	29/01/23 05:15
242	Wk 5	29/01/23 07:30
243	Wk 5	29/01/23 09:54
244	Wk 5	29/01/23 06:45
245	Wk 5	29/01/23 20:15
246	Wk 5	30/01/23 07:10
247	Wk 5	30/01/23 00:40
248	Wk 5	30/01/23 05:35
249	Wk 5	30/01/23 16:15
250	Wk 5	30/01/23 23:30
251	Wk 5	30/01/23 20:40
252	Wk 5	30/01/23 18:10
253	Wk 5	31/01/23 15:50
254	Wk 5	31/01/23 06:30
255	Wk 5	31/01/23 10:30
256	Wk 5	31/01/23 23:00
257	Wk 5	31/01/23 22:25
258	Wk 5	31/01/23 22:20
259	Wk 1	01/02/23 02:35
260	Wk 1	01/02/23 02:15
261	Wk 1	01/02/23 05:00
262	Wk 1	01/02/23 12:45
263	Wk 1	01/02/23 17:15
264	Wk 1	01/02/23 17:50
265	Wk 1	01/02/23 23:15
266	Wk 1	02/02/23 12:10
267	Wk 1	02/02/23 06:20
268	Wk 1	01/02/23 22:45
269	Wk 1	02/02/23 11:06
270	Wk 1	02/02/23 09:00
271	Wk 1	02/02/23 14:30
272	Wk 1	02/02/23 15:10
273	Wk 1	02/02/23 15:00
274	Wk 1	02/02/23 18:35
275	Wk 1	02/02/23 23:00
276	Wk 1	02/02/23 08:35
277	Wk 1	03/02/23 06:55
278	Wk 1	03/02/23 01:45
279	Wk 1	03/02/23 08:20
280	Wk 1	03/02/23 01:00
281	Wk 1	02/02/23 23:36
282	Wk 1	03/02/23 09:00
283	Wk 1	04/02/23 03:35
284	Wk 1	04/02/23 04:00
285	Wk 1	04/02/23 03:30
286	Wk 1	04/02/23 07:15
287	Wk 1	04/02/23 01:15
288	Wk 1	04/02/23 05:15
289	Wk 1	04/02/23 06:15
290	Wk 1	04/02/23 14:55
291	Wk 1	04/02/23 19:18
292	Wk 1	04/02/23 22:50
293	Wk 2	05/02/23 00:45
294	Wk 2	05/02/23 03:00
295	Wk 2	05/02/23 17:36
296	Wk 2	05/02/23 15:35
297	Wk 2	05/02/23 05:20
298	Wk 2	05/02/23 05:35
299	Wk 2	05/02/23 03:45
300	Wk 2	05/02/23 16:15
301	Wk 2	05/02/23 17:20
302	Wk 2	06/02/23 02:00
303	Wk 2	05/02/23 21:05
304	Wk 2	05/02/23 22:45
305	Wk 2	06/02/23 06:40
306	Wk 2	06/02/23 04:25
307	Wk 2	05/02/23 00:45
308	Wk 2	06/02/23 06:35
309	Wk 2	06/02/23 00:15
310	Wk 2	06/02/23 03:50
311	Wk 2	05/02/23 23:06
312	Wk 2	06/02/23 02:10
313	Wk 2	07/02/23 07:45
314	Wk 2	07/02/23 12:10
315	Wk 2	07/02/23 13:20
316	Wk 2	07/02/23 18:00
317	Wk 2	07/02/23 18:35
318	Wk 2	07/02/23 13:20
319	Wk 2	08/02/23 00:40
320	Wk 2	08/02/23 18:25
321	Wk 2	09/02/23 19:54
322	Wk 2	10/02/23 01:30
323	Wk 2	10/02/23 00:30
324	Wk 2	09/02/23 08:48
325	Wk 2	10/02/23 04:50
326	Wk 2	10/02/23 04:00
327	Wk 2	10/02/23 09:20
328	Wk 2	10/02/23 15:25
329	Wk 2	10/02/23 18:50
330	Wk 2	10/02/23 20:22
331	Wk 2	11/02/23 03:10
332	Wk 2	11/02/23 11:10
333	Wk 2	11/02/23 02:20
334	Wk 2	11/02/23 07:30
335	Wk 2	11/02/23 09:10
336	Wk 2	11/02/23 16:30
337	Wk 2	11/02/23 16:45
338	Wk 2	11/02/23 21:15
339	Wk 2	11/02/23 22:25
340	Wk 3	12/02/23 12:42
341	Wk 2	11/02/23 23:59
342	Wk 3	12/02/23 03:05
343	Wk 3	12/02/23 02:25
344	Wk 3	12/02/23 01:15
345	Wk 3	12/02/23 03:05
346	Wk 3	12/02/23 09:50
347	Wk 3	12/02/23 02:12
348	Wk 3	12/02/23 19:45
349	Wk 3	12/02/23 12:00
350	Wk 3	12/02/23 08:55
351	Wk 3	12/02/23 10:30
352	Wk 3	12/02/23 11:30
353	Wk 3	12/02/23 12:40
354	Wk 3	12/02/23 12:20
355	Wk 3	12/02/23 16:10
356	Wk 3	12/02/23 22:10
357	Wk 3	12/02/23 22:05
358	Wk 3	12/02/23 22:45
359	Wk 3	12/02/23 20:10
360	Wk 3	12/02/23 21:20
361	Wk 3	13/02/23 04:00
362	Wk 3	13/02/23 04:00
363	Wk 3	13/02/23 12:10
364	Wk 3	13/02/23 15:00
365	Wk 3	13/02/23 12:40
366	Wk 3	13/02/23 10:45
367	Wk 3	13/02/23 12:20
368	Wk 3	13/02/23 20:35
369	Wk 3	14/02/23 03:20
370	Wk 3	14/02/23 00:15
371	Wk 3	14/02/23 01:15
372	Wk 3	14/02/23 14:36
373	Wk 3	14/02/23 19:15
374	Wk 3	14/02/23 20:27
375	Wk 3	15/02/23 10:25
376	Wk 3	15/02/23 20:45
377	Wk 3	15/02/23 23:00
378	Wk 3	15/02/23 15:55
379	Wk 3	15/02/23 16:50
380	Wk 3	16/02/23 07:30
381	Wk 3	15/02/23 23:45
382	Wk 3	15/02/23 23:25
383	Wk 3	16/02/23 01:35
384	Wk 3	16/02/23 04:05
385	Wk 3	15/02/23 23:20
386	Wk 3	15/02/23 22:48
387	Wk 3	15/02/23 22:12
388	Wk 3	16/02/23 03:00
389	Wk 3	16/02/23 00:45
390	Wk 3	16/02/23 08:00
391	Wk 3	16/02/23 08:05
392	Wk 3	16/02/23 18:18
393	Wk 3	17/02/23 01:20
394	Wk 3	17/02/23 01:25
395	Wk 3	16/02/23 22:42
396	Wk 3	17/02/23 05:55
397	Wk 3	17/02/23 11:50
398	Wk 3	17/02/23 05:35
399	Wk 3	16/02/23 23:55
400	Wk 3	17/02/23 04:50
401	Wk 3	16/02/23 23:18
402	Wk 3	17/02/23 11:45
403	Wk 3	17/02/23 11:20
404	Wk 3	17/02/23 14:20
405	Wk 3	17/02/23 14:12
406	Wk 3	17/02/23 14:15
407	Wk 3	17/02/23 23:15
408	Wk 3	18/02/23 01:20
409	Wk 3	17/02/23 22:20
410	Wk 3	18/02/23 10:05
411	Wk 3	18/02/23 03:30
412	Wk 3	18/02/23 09:50
413	Wk 3	18/02/23 08:00
414	Wk 3	18/02/23 12:40
415	Wk 3	18/02/23 20:00
416	Wk 3	16/02/23 20:10
417	Wk 3	18/02/23 20:54
418	Wk 3	18/02/23 22:00
419	Wk 4	19/02/23 04:00
420	Wk 4	19/02/23 05:30
421	Wk 3	18/02/23 19:00
422	Wk 4	19/02/23 09:40
423	Wk 4	20/02/23 10:42
424	Wk 4	20/02/23 02:15
425	Wk 4	19/02/23 16:15
426	Wk 4	20/02/23 00:40
427	Wk 4	20/02/23 01:54
428	Wk 4	20/02/23 10:48
429	Wk 4	20/02/23 11:15
430	Wk 4	20/02/23 01:24
431	Wk 4	20/02/23 12:35
432	Wk 4	20/02/23 19:30
433	Wk 4	20/02/23 14:10
434	Wk 4	20/02/23 17:20
435	Wk 4	20/02/23 21:10
436	Wk 4	21/02/23 01:20
437	Wk 4	21/02/23 14:45
438	Wk 4	21/02/23 03:40
439	Wk 4	21/02/23 00:30
440	Wk 4	20/02/23 23:45
441	Wk 4	21/02/23 03:40
442	Wk 4	21/02/23 07:15
443	Wk 4	22/02/23 07:40
444	Wk 4	21/02/23 14:20
445	Wk 4	21/02/23 16:00
446	Wk 4	21/02/23 19:08
447	Wk 4	21/02/23 16:25
448	Wk 4	21/02/23 22:40
449	Wk 4	22/02/23 01:30
450	Wk 4	21/02/23 23:50
451	Wk 4	22/02/23 00:15
452	Wk 4	22/02/23 04:24
453	Wk 4	22/02/23 06:18
454	Wk 4	22/02/23 18:00
455	Wk 4	22/02/23 06:18
456	Wk 4	22/02/23 23:50
457	Wk 4	23/02/23 07:40
458	Wk 4	23/02/23 11:10
459	Wk 4	23/02/23 20:40
460	Wk 4	23/02/23 22:00
461	Wk 4	23/02/23 21:45
462	Wk 4	20/02/23 11:12
463	Wk 4	23/02/23 22:00
464	Wk 4	23/02/23 21:30
465	Wk 4	24/02/23 03:45
466	Wk 4	24/02/23 00:20
467	Wk 4	24/02/23 03:52
468	Wk 4	24/02/23 08:40
469	Wk 4	24/02/23 16:25
470	Wk 4	24/02/23 22:40
471	Wk 4	24/02/23 19:45
472	Wk 4	24/02/23 19:40
473	Wk 4	25/02/23 03:15
474	Wk 4	25/02/23 09:30
475	Wk 4	24/02/23 21:45
476	Wk 4	25/02/23 17:15
477	Wk 4	25/02/23 08:30
478	Wk 4	25/02/23 04:15
479	Wk 4	25/02/23 17:40
480	Wk 4	25/02/23 23:15
481	Wk 4	25/02/23 14:35
482	Wk 4	25/02/23 23:00
483	Wk 5	26/02/23 01:35
484	Wk 5	26/02/23 03:20
485	Wk 5	26/02/23 00:45
486	Wk 5	26/02/23 09:45
487	Wk 5	26/02/23 05:50
488	Wk 5	26/02/23 09:15
489	Wk 5	26/02/23 07:18
490	Wk 5	26/02/23 06:48
491	Wk 5	26/02/23 10:15
492	Wk 5	26/02/23 05:15
493	Wk 5	26/02/23 15:00
494	Wk 5	26/02/23 15:00
495	Wk 5	26/02/23 18:20
496	Wk 5	27/02/23 06:20
497	Wk 5	27/02/23 10:18
498	Wk 5	27/02/23 02:05
499	Wk 5	27/02/23 12:42
500	Wk 5	27/02/23 04:40
501	Wk 5	27/02/23 13:00
502	Wk 5	26/02/23 02:20
503	Wk 5	27/02/23 17:50
504	Wk 5	27/02/23 11:45
505	Wk 5	28/02/23 02:00
506	Wk 5	27/02/23 22:54
507	Wk 5	28/02/23 08:45
508	Wk 5	28/02/23 05:30
509	Wk 5	27/02/23 22:24
510	Wk 5	27/02/23 22:15
511	Wk 5	28/02/23 07:05
512	Wk 5	28/02/23 06:35
513	Wk 1	01/03/23 00:54
514	Wk 5	28/02/23 17:00
515	Wk 5	28/02/23 21:54
516	Wk 5	28/02/23 22:50
517	Wk 1	01/03/23 03:30
518	Wk 5	28/02/23 20:40
Sheet3

 

[Anonymous1378]

Try this?

Book2
	A	B
1	Week Number	Date & Time
2	1	01/01/2023 12:00:00
3	1	01/01/2023 14:35:00
4	1	01/01/2023 18:10:00
5	1	01/01/2023 17:45:00
6	1	01/01/2023 18:05:00
7	1	01/01/2023 18:15:00
8	1	02/01/2023 1:40:00
9	1	02/01/2023 20:00:00
10	1	02/01/2023 19:15:00
11	1	02/01/2023 22:30:00
12	1	03/01/2023 14:50:00
13	1	03/01/2023 21:24:00
14	1	04/01/2023 16:45:00
15	1	03/01/2023 13:20:00
16	1	04/01/2023 0:50:00
17	1	04/01/2023 0:40:00
18	1	04/01/2023 0:20:00
19	1	03/01/2023 23:20:00
20	1	04/01/2023 3:30:00
21	1	03/01/2023 23:40:00
22	1	04/01/2023 12:30:00
23	1	04/01/2023 8:10:00
24	1	05/01/2023 4:35:00
25	1	04/01/2023 17:30:00
26	1	04/01/2023 19:00:00
27	1	04/01/2023 20:00:00
28	1	05/01/2023 11:00:00
29	1	05/01/2023 4:35:00
30	1	05/01/2023 14:05:00
31	1	05/01/2023 14:40:00
32	1	05/01/2023 16:48:00
33	1	05/01/2023 23:00:00
34	1	06/01/2023 0:20:00
35	1	05/01/2023 22:10:00
36	1	06/01/2023 0:50:00
37	1	06/01/2023 4:40:00
38	1	06/01/2023 23:30:00
39	1	07/01/2023 3:30:00
40	1	07/01/2023 0:10:00
41	1	07/01/2023 2:00:00
42	2	08/01/2023 6:35:00
43	2	08/01/2023 6:30:00
44	2	08/01/2023 7:10:00
45	2	08/01/2023 10:45:00
46	2	08/01/2023 16:45:00
47	2	08/01/2023 10:00:00
48	2	08/01/2023 19:53:00
49	2	08/01/2023 21:27:00
50	2	08/01/2023 17:45:00
51	2	08/01/2023 17:12:00
52	2	08/01/2023 21:10:00
53	2	08/01/2023 17:20:00
54	2	09/01/2023 8:30:00
55	2	09/01/2023 3:00:00
56	2	09/01/2023 6:54:00
57	2	09/01/2023 3:15:00
58	2	09/01/2023 4:00:00
59	2	09/01/2023 5:25:00
60	2	09/01/2023 9:50:00
61	2	08/01/2023 23:50:00
62	2	09/01/2023 12:15:00
63	2	10/01/2023 9:05:00
64	2	09/01/2023 17:20:00
65	2	09/01/2023 14:00:00
66	2	09/01/2023 21:00:00
67	2	09/01/2023 23:50:00
68	2	10/01/2023 14:45:00
69	2	10/01/2023 14:30:00
70	2	10/01/2023 15:15:00
71	2	10/01/2023 23:05:00
72	2	10/01/2023 19:55:00
73	2	10/01/2023 20:00:00
74	2	11/01/2023 2:05:00
75	2	10/01/2023 22:10:00
76	2	10/01/2023 21:20:00
77	2	10/01/2023 22:15:00
78	2	10/01/2023 23:59:00
79	2	11/01/2023 0:45:00
80	1	05/01/2023 13:10:00
81	2	10/01/2023 21:45:00
82	2	11/01/2023 4:25:00
83	2	11/01/2023 13:35:00
84	2	12/01/2023 4:10:00
85	2	11/01/2023 20:50:00
86	2	11/01/2023 20:35:00
87	2	12/01/2023 9:55:00
88	2	12/01/2023 13:40:00
89	2	13/01/2023 1:00:00
90	2	12/01/2023 12:00:00
91	2	12/01/2023 13:10:00
92	2	12/01/2023 12:30:00
93	2	12/01/2023 16:45:00
94	2	12/01/2023 16:25:00
95	2	12/01/2023 16:30:00
96	2	12/01/2023 16:55:00
97	2	12/01/2023 21:20:00
98	2	11/01/2023 21:05:00
99	2	12/01/2023 22:05:00
100	2	12/01/2023 22:30:00
101	2	13/01/2023 10:12:00
102	2	13/01/2023 5:30:00
103	2	13/01/2023 4:40:00
104	2	13/01/2023 9:40:00
105	2	13/01/2023 14:35:00
106	2	13/01/2023 16:30:00
107	2	13/01/2023 19:12:00
108	2	13/01/2023 18:12:00
109	2	13/01/2023 19:40:00
110	2	14/01/2023 3:15:00
111	2	14/01/2023 6:30:00
112	2	14/01/2023 9:00:00
113	2	14/01/2023 0:40:00
114	2	14/01/2023 15:05:00
115	2	14/01/2023 14:15:00
116	2	14/01/2023 13:50:00
117	2	14/01/2023 21:25:00
118	3	15/01/2023 0:35:00
119	2	14/01/2023 23:59:00
120	3	15/01/2023 3:25:00
121	2	14/01/2023 21:20:00
122	2	14/01/2023 7:30:00
123	3	15/01/2023 2:42:00
124	3	15/01/2023 1:40:00
125	3	15/01/2023 2:54:00
126	3	15/01/2023 2:40:00
127	3	15/01/2023 11:50:00
128	3	15/01/2023 10:00:00
129	3	15/01/2023 15:45:00
130	3	15/01/2023 12:36:00
131	3	15/01/2023 23:00:00
132	3	16/01/2023 21:00:00
133	3	16/01/2023 21:05:00
134	3	16/01/2023 19:50:00
135	3	16/01/2023 21:30:00
136	3	17/01/2023 0:45:00
137	3	16/01/2023 7:25:00
138	3	17/01/2023 11:35:00
139	3	18/01/2023 2:20:00
140	3	17/01/2023 15:36:00
141	3	17/01/2023 23:35:00
142	3	17/01/2023 21:25:00
143	3	18/01/2023 3:26:00
144	3	16/01/2023 22:25:00
145	3	18/01/2023 4:45:00
146	3	18/01/2023 5:10:00
147	3	18/01/2023 11:50:00
148	3	18/01/2023 0:07:00
149	3	18/01/2023 5:00:00
150	3	18/01/2023 15:45:00
151	3	18/01/2023 15:35:00
152	3	18/01/2023 13:50:00
153	3	18/01/2023 17:30:00
154	3	18/01/2023 17:30:00
155	3	18/01/2023 20:20:00
156	3	19/01/2023 1:30:00
157	3	19/01/2023 3:10:00
158	3	19/01/2023 1:30:00
159	3	19/01/2023 2:30:00
160	3	19/01/2023 7:36:00
161	3	19/01/2023 19:00:00
162	3	20/01/2023 0:15:00
163	3	20/01/2023 4:55:00
164	3	20/01/2023 6:10:00
165	3	19/01/2023 22:40:00
166	3	20/01/2023 0:50:00
167	3	20/01/2023 8:00:00
168	3	20/01/2023 14:25:00
169	3	20/01/2023 2:06:00
170	3	21/01/2023 2:00:00
171	3	21/01/2023 1:25:00
172	3	21/01/2023 0:54:00
173	3	21/01/2023 1:05:00
174	4	22/01/2023 11:25:00
175	3	21/01/2023 2:55:00
176	4	23/01/2023 5:10:00
177	4	23/01/2023 5:00:00
178	4	23/01/2023 9:00:00
179	4	23/01/2023 13:10:00
180	4	24/01/2023 9:40:00
181	4	24/01/2023 0:55:00
182	4	24/01/2023 3:18:00
183	4	24/01/2023 2:05:00
184	4	23/01/2023 23:00:00
185	4	24/01/2023 3:40:00
186	4	23/01/2023 23:25:00
187	4	24/01/2023 3:50:00
188	4	24/01/2023 9:30:00
189	4	24/01/2023 19:00:00
190	4	24/01/2023 20:45:00
191	4	24/01/2023 20:05:00
192	4	24/01/2023 23:10:00
193	4	25/01/2023 0:15:00
194	4	25/01/2023 1:45:00
195	4	25/01/2023 8:15:00
196	4	25/01/2023 8:35:00
197	4	25/01/2023 9:30:00
198	4	25/01/2023 12:30:00
199	4	25/01/2023 16:54:00
200	4	25/01/2023 21:40:00
201	4	25/01/2023 22:15:00
202	4	26/01/2023 0:00:00
203	4	26/01/2023 4:30:00
204	4	26/01/2023 12:54:00
205	4	26/01/2023 8:30:00
206	4	26/01/2023 9:25:00
207	4	26/01/2023 15:15:00
208	4	26/01/2023 17:55:00
209	4	26/01/2023 15:45:00
210	4	26/01/2023 20:35:00
211	4	27/01/2023 3:15:00
212	4	27/01/2023 14:20:00
213	4	27/01/2023 0:01:00
214	4	27/01/2023 16:05:00
215	4	27/01/2023 13:05:00
216	4	27/01/2023 7:15:00
217	4	27/01/2023 7:00:00
218	4	27/01/2023 6:15:00
219	4	27/01/2023 12:40:00
220	4	27/01/2023 15:00:00
221	4	27/01/2023 23:35:00
222	4	27/01/2023 21:41:00
223	4	28/01/2023 6:35:00
224	4	28/01/2023 2:20:00
225	4	27/01/2023 21:48:00
226	4	26/01/2023 12:54:00
227	4	28/01/2023 7:35:00
228	4	28/01/2023 0:50:00
229	4	28/01/2023 10:00:00
230	5	29/01/2023 7:25:00
231	4	28/01/2023 9:50:00
232	4	28/01/2023 9:20:00
233	4	28/01/2023 14:00:00
234	4	28/01/2023 17:40:00
235	5	29/01/2023 0:55:00
236	4	28/01/2023 17:20:00
237	4	28/01/2023 19:40:00
238	5	29/01/2023 5:00:00
239	5	29/01/2023 11:10:00
240	5	29/01/2023 5:15:00
241	5	29/01/2023 7:30:00
242	5	29/01/2023 9:54:00
243	5	29/01/2023 6:45:00
244	5	29/01/2023 20:15:00
245	5	30/01/2023 7:10:00
246	5	30/01/2023 0:40:00
247	5	30/01/2023 5:35:00
248	5	30/01/2023 16:15:00
249	5	30/01/2023 23:30:00
250	5	30/01/2023 20:40:00
251	5	30/01/2023 18:10:00
252	5	31/01/2023 15:50:00
253	5	31/01/2023 6:30:00
254	5	31/01/2023 10:30:00
255	5	31/01/2023 23:00:00
256	5	31/01/2023 22:25:00
257	5	31/01/2023 22:20:00
258	1	01/02/2023 2:35:00
259	1	01/02/2023 2:15:00
260	1	01/02/2023 5:00:00
261	1	01/02/2023 12:45:00
262	1	01/02/2023 17:15:00
263	1	01/02/2023 17:50:00
264	1	01/02/2023 23:15:00
265	1	02/02/2023 12:10:00
266	1	02/02/2023 6:20:00
267	1	01/02/2023 22:45:00
268	1	02/02/2023 11:06:00
269	1	02/02/2023 9:00:00
270	1	02/02/2023 14:30:00
271	1	02/02/2023 15:10:00
272	1	02/02/2023 15:00:00
273	1	02/02/2023 18:35:00
274	1	02/02/2023 23:00:00
275	1	02/02/2023 8:35:00
276	1	03/02/2023 6:55:00
277	1	03/02/2023 1:45:00
278	1	03/02/2023 8:20:00
279	1	03/02/2023 1:00:00
280	1	02/02/2023 23:36:00
281	1	03/02/2023 9:00:00
282	1	04/02/2023 3:35:00
283	1	04/02/2023 4:00:00
284	1	04/02/2023 3:30:00
285	1	04/02/2023 7:15:00
286	1	04/02/2023 1:15:00
287	1	04/02/2023 5:15:00
288	1	04/02/2023 6:15:00
289	1	04/02/2023 14:55:00
290	1	04/02/2023 19:18:00
291	1	04/02/2023 22:50:00
292	2	05/02/2023 0:45:00
Sheet2

Cell Formulas
Range	Formula
A2:A292	A2	=MATCH(WEEKNUM(B2),ROW(INDIRECT(WEEKNUM(EOMONTH(B2,-1)+1)&":"&WEEKNUM(EOMONTH(B2,0)))))

 

[Phuoc]

Like this?

Book1
	A	B
1	Week Number	Date & Time
2	1	1/1/2023 12:00:00
3	5	31/1/2023 00:00:00
4	1	1/2/2023 00:00:00
5	5	28/2/2023 00:00:00
Sheet1

Cell Formulas
Range	Formula
A2:A5	A2	=WEEKNUM(B2)-WEEKNUM(EOMONTH(B2,-1)+1)+1

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
On this occasion I have merged both threads.

 

[Lukma]

Try this?

Book2
	A	B
1	Week Number	Date & Time
2	1	01/01/2023 12:00:00
3	1	01/01/2023 14:35:00
4	1	01/01/2023 18:10:00
5	1	01/01/2023 17:45:00
6	1	01/01/2023 18:05:00
7	1	01/01/2023 18:15:00
8	1	02/01/2023 1:40:00
9	1	02/01/2023 20:00:00
10	1	02/01/2023 19:15:00
11	1	02/01/2023 22:30:00
12	1	03/01/2023 14:50:00
13	1	03/01/2023 21:24:00
14	1	04/01/2023 16:45:00
15	1	03/01/2023 13:20:00
16	1	04/01/2023 0:50:00
17	1	04/01/2023 0:40:00
18	1	04/01/2023 0:20:00
19	1	03/01/2023 23:20:00
20	1	04/01/2023 3:30:00
21	1	03/01/2023 23:40:00
22	1	04/01/2023 12:30:00
23	1	04/01/2023 8:10:00
24	1	05/01/2023 4:35:00
25	1	04/01/2023 17:30:00
26	1	04/01/2023 19:00:00
27	1	04/01/2023 20:00:00
28	1	05/01/2023 11:00:00
29	1	05/01/2023 4:35:00
30	1	05/01/2023 14:05:00
31	1	05/01/2023 14:40:00
32	1	05/01/2023 16:48:00
33	1	05/01/2023 23:00:00
34	1	06/01/2023 0:20:00
35	1	05/01/2023 22:10:00
36	1	06/01/2023 0:50:00
37	1	06/01/2023 4:40:00
38	1	06/01/2023 23:30:00
39	1	07/01/2023 3:30:00
40	1	07/01/2023 0:10:00
41	1	07/01/2023 2:00:00
42	2	08/01/2023 6:35:00
43	2	08/01/2023 6:30:00
44	2	08/01/2023 7:10:00
45	2	08/01/2023 10:45:00
46	2	08/01/2023 16:45:00
47	2	08/01/2023 10:00:00
48	2	08/01/2023 19:53:00
49	2	08/01/2023 21:27:00
50	2	08/01/2023 17:45:00
51	2	08/01/2023 17:12:00
52	2	08/01/2023 21:10:00
53	2	08/01/2023 17:20:00
54	2	09/01/2023 8:30:00
55	2	09/01/2023 3:00:00
56	2	09/01/2023 6:54:00
57	2	09/01/2023 3:15:00
58	2	09/01/2023 4:00:00
59	2	09/01/2023 5:25:00
60	2	09/01/2023 9:50:00
61	2	08/01/2023 23:50:00
62	2	09/01/2023 12:15:00
63	2	10/01/2023 9:05:00
64	2	09/01/2023 17:20:00
65	2	09/01/2023 14:00:00
66	2	09/01/2023 21:00:00
67	2	09/01/2023 23:50:00
68	2	10/01/2023 14:45:00
69	2	10/01/2023 14:30:00
70	2	10/01/2023 15:15:00
71	2	10/01/2023 23:05:00
72	2	10/01/2023 19:55:00
73	2	10/01/2023 20:00:00
74	2	11/01/2023 2:05:00
75	2	10/01/2023 22:10:00
76	2	10/01/2023 21:20:00
77	2	10/01/2023 22:15:00
78	2	10/01/2023 23:59:00
79	2	11/01/2023 0:45:00
80	1	05/01/2023 13:10:00
81	2	10/01/2023 21:45:00
82	2	11/01/2023 4:25:00
83	2	11/01/2023 13:35:00
84	2	12/01/2023 4:10:00
85	2	11/01/2023 20:50:00
86	2	11/01/2023 20:35:00
87	2	12/01/2023 9:55:00
88	2	12/01/2023 13:40:00
89	2	13/01/2023 1:00:00
90	2	12/01/2023 12:00:00
91	2	12/01/2023 13:10:00
92	2	12/01/2023 12:30:00
93	2	12/01/2023 16:45:00
94	2	12/01/2023 16:25:00
95	2	12/01/2023 16:30:00
96	2	12/01/2023 16:55:00
97	2	12/01/2023 21:20:00
98	2	11/01/2023 21:05:00
99	2	12/01/2023 22:05:00
100	2	12/01/2023 22:30:00
101	2	13/01/2023 10:12:00
102	2	13/01/2023 5:30:00
103	2	13/01/2023 4:40:00
104	2	13/01/2023 9:40:00
105	2	13/01/2023 14:35:00
106	2	13/01/2023 16:30:00
107	2	13/01/2023 19:12:00
108	2	13/01/2023 18:12:00
109	2	13/01/2023 19:40:00
110	2	14/01/2023 3:15:00
111	2	14/01/2023 6:30:00
112	2	14/01/2023 9:00:00
113	2	14/01/2023 0:40:00
114	2	14/01/2023 15:05:00
115	2	14/01/2023 14:15:00
116	2	14/01/2023 13:50:00
117	2	14/01/2023 21:25:00
118	3	15/01/2023 0:35:00
119	2	14/01/2023 23:59:00
120	3	15/01/2023 3:25:00
121	2	14/01/2023 21:20:00
122	2	14/01/2023 7:30:00
123	3	15/01/2023 2:42:00
124	3	15/01/2023 1:40:00
125	3	15/01/2023 2:54:00
126	3	15/01/2023 2:40:00
127	3	15/01/2023 11:50:00
128	3	15/01/2023 10:00:00
129	3	15/01/2023 15:45:00
130	3	15/01/2023 12:36:00
131	3	15/01/2023 23:00:00
132	3	16/01/2023 21:00:00
133	3	16/01/2023 21:05:00
134	3	16/01/2023 19:50:00
135	3	16/01/2023 21:30:00
136	3	17/01/2023 0:45:00
137	3	16/01/2023 7:25:00
138	3	17/01/2023 11:35:00
139	3	18/01/2023 2:20:00
140	3	17/01/2023 15:36:00
141	3	17/01/2023 23:35:00
142	3	17/01/2023 21:25:00
143	3	18/01/2023 3:26:00
144	3	16/01/2023 22:25:00
145	3	18/01/2023 4:45:00
146	3	18/01/2023 5:10:00
147	3	18/01/2023 11:50:00
148	3	18/01/2023 0:07:00
149	3	18/01/2023 5:00:00
150	3	18/01/2023 15:45:00
151	3	18/01/2023 15:35:00
152	3	18/01/2023 13:50:00
153	3	18/01/2023 17:30:00
154	3	18/01/2023 17:30:00
155	3	18/01/2023 20:20:00
156	3	19/01/2023 1:30:00
157	3	19/01/2023 3:10:00
158	3	19/01/2023 1:30:00
159	3	19/01/2023 2:30:00
160	3	19/01/2023 7:36:00
161	3	19/01/2023 19:00:00
162	3	20/01/2023 0:15:00
163	3	20/01/2023 4:55:00
164	3	20/01/2023 6:10:00
165	3	19/01/2023 22:40:00
166	3	20/01/2023 0:50:00
167	3	20/01/2023 8:00:00
168	3	20/01/2023 14:25:00
169	3	20/01/2023 2:06:00
170	3	21/01/2023 2:00:00
171	3	21/01/2023 1:25:00
172	3	21/01/2023 0:54:00
173	3	21/01/2023 1:05:00
174	4	22/01/2023 11:25:00
175	3	21/01/2023 2:55:00
176	4	23/01/2023 5:10:00
177	4	23/01/2023 5:00:00
178	4	23/01/2023 9:00:00
179	4	23/01/2023 13:10:00
180	4	24/01/2023 9:40:00
181	4	24/01/2023 0:55:00
182	4	24/01/2023 3:18:00
183	4	24/01/2023 2:05:00
184	4	23/01/2023 23:00:00
185	4	24/01/2023 3:40:00
186	4	23/01/2023 23:25:00
187	4	24/01/2023 3:50:00
188	4	24/01/2023 9:30:00
189	4	24/01/2023 19:00:00
190	4	24/01/2023 20:45:00
191	4	24/01/2023 20:05:00
192	4	24/01/2023 23:10:00
193	4	25/01/2023 0:15:00
194	4	25/01/2023 1:45:00
195	4	25/01/2023 8:15:00
196	4	25/01/2023 8:35:00
197	4	25/01/2023 9:30:00
198	4	25/01/2023 12:30:00
199	4	25/01/2023 16:54:00
200	4	25/01/2023 21:40:00
201	4	25/01/2023 22:15:00
202	4	26/01/2023 0:00:00
203	4	26/01/2023 4:30:00
204	4	26/01/2023 12:54:00
205	4	26/01/2023 8:30:00
206	4	26/01/2023 9:25:00
207	4	26/01/2023 15:15:00
208	4	26/01/2023 17:55:00
209	4	26/01/2023 15:45:00
210	4	26/01/2023 20:35:00
211	4	27/01/2023 3:15:00
212	4	27/01/2023 14:20:00
213	4	27/01/2023 0:01:00
214	4	27/01/2023 16:05:00
215	4	27/01/2023 13:05:00
216	4	27/01/2023 7:15:00
217	4	27/01/2023 7:00:00
218	4	27/01/2023 6:15:00
219	4	27/01/2023 12:40:00
220	4	27/01/2023 15:00:00
221	4	27/01/2023 23:35:00
222	4	27/01/2023 21:41:00
223	4	28/01/2023 6:35:00
224	4	28/01/2023 2:20:00
225	4	27/01/2023 21:48:00
226	4	26/01/2023 12:54:00
227	4	28/01/2023 7:35:00
228	4	28/01/2023 0:50:00
229	4	28/01/2023 10:00:00
230	5	29/01/2023 7:25:00
231	4	28/01/2023 9:50:00
232	4	28/01/2023 9:20:00
233	4	28/01/2023 14:00:00
234	4	28/01/2023 17:40:00
235	5	29/01/2023 0:55:00
236	4	28/01/2023 17:20:00
237	4	28/01/2023 19:40:00
238	5	29/01/2023 5:00:00
239	5	29/01/2023 11:10:00
240	5	29/01/2023 5:15:00
241	5	29/01/2023 7:30:00
242	5	29/01/2023 9:54:00
243	5	29/01/2023 6:45:00
244	5	29/01/2023 20:15:00
245	5	30/01/2023 7:10:00
246	5	30/01/2023 0:40:00
247	5	30/01/2023 5:35:00
248	5	30/01/2023 16:15:00
249	5	30/01/2023 23:30:00
250	5	30/01/2023 20:40:00
251	5	30/01/2023 18:10:00
252	5	31/01/2023 15:50:00
253	5	31/01/2023 6:30:00
254	5	31/01/2023 10:30:00
255	5	31/01/2023 23:00:00
256	5	31/01/2023 22:25:00
257	5	31/01/2023 22:20:00
258	1	01/02/2023 2:35:00
259	1	01/02/2023 2:15:00
260	1	01/02/2023 5:00:00
261	1	01/02/2023 12:45:00
262	1	01/02/2023 17:15:00
263	1	01/02/2023 17:50:00
264	1	01/02/2023 23:15:00
265	1	02/02/2023 12:10:00
266	1	02/02/2023 6:20:00
267	1	01/02/2023 22:45:00
268	1	02/02/2023 11:06:00
269	1	02/02/2023 9:00:00
270	1	02/02/2023 14:30:00
271	1	02/02/2023 15:10:00
272	1	02/02/2023 15:00:00
273	1	02/02/2023 18:35:00
274	1	02/02/2023 23:00:00
275	1	02/02/2023 8:35:00
276	1	03/02/2023 6:55:00
277	1	03/02/2023 1:45:00
278	1	03/02/2023 8:20:00
279	1	03/02/2023 1:00:00
280	1	02/02/2023 23:36:00
281	1	03/02/2023 9:00:00
282	1	04/02/2023 3:35:00
283	1	04/02/2023 4:00:00
284	1	04/02/2023 3:30:00
285	1	04/02/2023 7:15:00
286	1	04/02/2023 1:15:00
287	1	04/02/2023 5:15:00
288	1	04/02/2023 6:15:00
289	1	04/02/2023 14:55:00
290	1	04/02/2023 19:18:00
291	1	04/02/2023 22:50:00
292	2	05/02/2023 0:45:00
Sheet2

Cell Formulas
Range	Formula
A2:A292	A2	=MATCH(WEEKNUM(B2),ROW(INDIRECT(WEEKNUM(EOMONTH(B2,-1)+1)&":"&WEEKNUM(EOMONTH(B2,0)))))

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)))))

 

[Lukma]

Like this?

Book1
	A	B
1	Week Number	Date & Time
2	1	1/1/2023 12:00:00
3	5	31/1/2023 00:00:00
4	1	1/2/2023 00:00:00
5	5	28/2/2023 00:00:00
Sheet1

Cell Formulas
Range	Formula
A2:A5	A2	=WEEKNUM(B2)-WEEKNUM(EOMONTH(B2,-1)+1)+1

Hi phuoc

thank so much i tried and drag down but when it comes to July it is giving week 6 please see the data do I miss-out anything because I tried and also enter directly

Appreciate your support little more July wk is 5 but in my data am getting wk 6 close to the ending of July

Regards

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

Cell Formulas
Range	Formula
C340:C373	C340	=WEEKNUM(B340)-WEEKNUM(EOMONTH(B340,-1)+1)+1