You can do it in a single select by using SQL Server ability to count Weeks.

You only have to subtract from your two dates the 'dayofweek' value of the day...