Excel WEEKNUM function with an optional second argument of 1 (default). Week 1 begins on January 1st; week two begins on the following Sunday.

 

Example:

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

 

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