Hi

In C3.

=INT((DAY(A3)-1)/7)+1


Copy down