Date for Monday and Friday of Current Week

The Date for Monday and Friday of the current week can be determined as illustrated below.

SELECT GETDATE() + (2 – DATEPART(WEEKDAY, GETDATE())) AS MONDAY,GETDATE() + (6 – DATEPART(WEEKDAY, GETDATE())) AS FRIDAY

This assumes that you consider the first day of the week to be a Sunday and that the last day of the week is a Saturday.  If this is not the case you will need to use the SET DATEFIRST to set the first day of the week to a number from 1 through 7.  ie. SET DATEFIRST 1 to set MONDAY.  To determine the day that is currently set as the first day of the week run SELECT @@DATEFIRST (by default this is 7 which is Sunday).