• This should give you the next Friday

    set datefirst 6

    print dateadd(wk,datepart(wk,getdate())-1,'2014-01-01')+2