sql for day of the week in the future

SET DATEFIRST 1
DECLARE @dt DATE
SET @dt = '2011-05-13'
SELECT DATEADD(day,
    CASE 
      WHEN datepart(weekday,@dt)<2 
      THEN 2-datepart(weekday,@dt) 
      ELSE 9-datepart(weekday,@dt) 
    END,
    @dt)

simplest way without complicated arithmetic operations is

declare @dte    date

select  @dte = '2011-10-17'

select  dateadd(day,
       case  datename(weekday, @dte)
         when 'Sunday' then 2
         when 'Monday' then 1
         when 'Tuesday' then 7
         when 'Wednesday' then 6
         when 'Thursday' then 5
         when 'Friday' then 4
         when 'Saturday' then 3
         end,
       @dte)

all of the time - so it should not matter if it's thur or friday at the time the query id executed, tue should be the return date.