Say I have variable @date populated with 2017-07-19, and I want variable @Monday to be the Next Monday after @date, how would I accomplish this?
Also, how complex would it be to add a sort of case statement that if @date is currently a Monday, then simply set @Monday as that date?