So which is really better - the very clever one-liner whose logic can't be unravelled without some head scratching, or the somewhat longer version that's simple enough to be self-explanatory?
[font="Courier New"]select @TargetDate = dateadd(dd,@DaysOut,@StartDate)
while datepart(dw,@TargetDate) <> @DesiredDayOfWeek
set @TargetDate = @TargetDate + 1[/font]