Your problem is that you are adding the number of weeks to the base date of zero (1 January 1900), which happened to be a Monday. Changing your queries to something like

DATEADD ( wk, DATEDIFF ( wk, 0, GETDATE() ), '1899-12-31' )

will give you the correct result if you want the week to start on Sunday.

Regards,

Jan