Hi,

Try

=WEEKNUM(C2,1)


Return_type is a number that determines on which day the week begins. The default is 1.

Return_type Week Begins

1 Week begins on Sunday. Weekdays are numbered 1 through 7.
2 Week begins on Monday. Weekdays are numbered 1 through 7.