Calculate number of weeks between dates

Try:

select datediff(week,'9/1/2014', '9/28/2014') --4
, datediff(week,'6/3/2014', '9/12/2014') --14