If you like to use the united states calendar week.

Then try.


=ROUNDDOWN((A2-DATE(YEAR(A2),1,1))/7,0)+1


Hope it helps!