Most of the time I see systems having Sunday's as the first day of the week, as is the default for the Outlook calendar.

Have a look with this :

SELECT @@DATEFIRST

You will probably get 7. If so can use this in the SQL that pulls for your report if you have version 2008 and up::

DECLARE @dd datetime='2014-10-11'; /* THE DELIVERY DATE, play with this value */

SELECT

CASE

WHEN (@DD < DATEADD(D,7-DATEPART(DW,GETDATE()), CAST(GETDATE() AS DATE)))

THEN DATEADD(D,6-DATEPART(DW,GETDATE()), CAST(GETDATE() AS DATE))

ELSE

DATEADD(D,6-DATEPART(DW,@DD), @DD)

END AS SCHEDULED_DELIVERY_DATE

If you have version 2005 let me know for there are a couple ways to disregard the time portion from the output value