Calculating Per Diems Across Multiple Weeks

I am really stumped on this one and need some help. The user will select the Hotel In - is on or after (this is actually the Hotel Check-Out Date to give me one part of the range). Then they will sel...