WEEKOFYEAR() returns calendar week number of the year 1-53

Example

SELECT WEEKOFYEAR('1999-02-03')

Returns

5