want to extract week number for every month

[trivedi]

Hi,
I have data of 2019 - in weeknuumber column i need week num as per month
for ex in jan week column i am getting 1,2,3,4 when we see feb data, the week num should ot be 5,6,7,8 - they should be agian 1,2,3,4

Time		week
Week	Ending	1/14/2018​	3​
Week	Ending	1/21/2018​	4​
Week	Ending	1/28/2018​	5​
Week	Ending	2/4/2018​	6​
Week	Ending	2/11/2018​	7​
Week	Ending	2/18/2018​	8​
Week	Ending	2/25/2018​	9​
Week	Ending	3/4/2018​	10​
Week	Ending	3/11/2018​	11​
Week	Ending	3/18/2018​	12​
Week	Ending	3/25/2018​	13​
Week	Ending	4/1/2018​	14​
Week	Ending	4/8/2018​	15​
Week	Ending	4/15/2018​	16​
Week	Ending	4/22/2018​	17​
Week	Ending	4/29/2018​	18​
Week	Ending	5/6/2018​	19​
Week	Ending	5/13/2018​	20​
Week	Ending	5/20/2018​	21​
Week	Ending	5/27/2018​	22​
Week	Ending	6/3/2018​	23​
Week	Ending	6/10/2018​	24​
Week	Ending	6/17/2018​	25​
Week	Ending	6/24/2018​	26​
Week	Ending	7/1/2018​	27​
Week	Ending	7/8/2018​	28​
Week	Ending	7/15/2018​	29​
Week	Ending	7/22/2018​	30​
Week	Ending	7/29/2018​	31​
Week	Ending	8/5/2018​	32​
Week	Ending	8/12/2018​	33​
Week	Ending	8/19/2018​	34​
Week	Ending	8/26/2018​	35​
Week	Ending	9/2/2018​	36​
Week	Ending	9/9/2018​	37​
Week	Ending	9/16/2018​	38​
Week	Ending	9/23/2018​	39​
Week	Ending	9/30/2018​	40​
Week	Ending	10/7/2018​	41​
Week	Ending	10/14/2018​	42​
Week	Ending	10/21/2018​	43​
Week	Ending	10/28/2018​	44​
Week	Ending	11/4/2018​	45​
Week	Ending	11/11/2018​	46​
Week	Ending	11/18/2018​	47​
Week	Ending	11/25/2018​	48​
Week	Ending	12/2/2018​	49​
Week	Ending	12/9/2018​	50​
Week	Ending	12/16/2018​	51​
Week	Ending	12/23/2018​	52​

 

[James006]

Hi,
You can test following

=WEEKNUM(C2)-WEEKNUM(DATE(YEAR(C2),MONTH(C2),1))+1

 

[trivedi]

Hi,
You can test following

=WEEKNUM(C2)-WEEKNUM(DATE(YEAR(C2),MONTH(C2),1))+1

Thanks

 

[sucett]

Thanks

this also does the trick:
=INT((DAY(C2)-1)/7)+1