how do i create Periods and weeks (think business reports) using 2 date ranges
I would suggest that you create a Calendar Table that you can use for decades to come.  You create it once and use if for almost forever.

Examples: 

Aaron Bertrand's Creating a date dimension or calendar table in SQL Server

Himanshu Sharma &amp; Mohammad Nizamuddin in TechNet T-SQL: Calendar Table