• I think this is what you are looking for -

    select (DATEADD(wk, DATEDIFF(wk, 6, getDate() - 15), 7))

    Just put the no of days old date you want in place of 15...

    :rolleyes: