Help with Formula List down Week Numbers in each Month

[Lukma]

Hi Friends

I was trying to create a formula that can list down the week number for each month, which means the moment I change the month in column B3
the week numbers for that month will generate from Cell B4 as WK 1, Cell B5 as Wk-2, Cell B6 as Wk-3 , Cell B7 as Wk-4, Cell B8 as Wk-5
I will appreciate a formula that can carry out this so that whenever i change the month it will generate all week's numbers respectively for each month

Regards

2023-Master Data Onshore Jetty Operation Tracking.xlsx
	B	C	D	E	F
3	01/02/2023	ADNOC-221	ADNOC-222	ADNOC-223	ADNOC-224
4	1
5	2
6	3
7	4
8	5
Vsl Trip

 

[rabsofty]

in cell b4 =WEEKNUM(B3,1)
in cell b5 =B4+1
in cell b6 =B5+1
in cell b7 =B6+1
in cell b8 =B7+1

 

[Lukma]

Hi Rabsofty

Thank you, but this is not what I required I need each time I click and change the month the week will start from one

Regards

 

[rabsofty]

if i understand you, no matter what month you change to, the week number will start at 1.
if that's the case then simply leave the numbers 1 to 5 there always.

If this is not so, clarify with another sample with the month different

 

[Lukma]

if i understand you, no matter what month you change to, the week number will start at 1.
if that's the case then simply leave the numbers 1 to 5 there always.

If this is not so, clarify with another sample with the month different

Dear Rabsofty

Thank you I was able to extract the month-week number range with the index & match just to same me

i appreciate advise

Regards