Date and weeknumber formula count

[Joneye]

For the smart cookies here, what im looking for is a fomula that will check the year (2025), then count the week number, so the report using the below data would be

Forumula Help
1. 2024 Wek 48 1
2. 2025 Wek 48 2



Below is the data

Created On	WK #
27/11/24	48
27/11/25	48
27/11/25	48

 

[Cubist]

Try:

Book1
	A	B	C
1	27/11/24	48	1
2	27/11/25	48	2
Sheet4

Cell Formulas
Range	Formula
B1:B2	B1	=WEEKNUM(A1)
C1:C2	C1	=COUNTIFS($B$1:B1,B1)