Excel WEEKNUM function with an optional second argument of 2. Week 1 begins on January 1st; week two begins on the following Monday.

 

Example:

SELECT WEEKE2({d '2006-11-19'}) returns 47

 

The results of the SQL expression are shown in the third column.