Below Script gives you three important details related to date using datepart() function.

Current Week of the Year

Start of Week Date

End of Week Date

when we will execute the below script we will get the output like below:-

SELECT DATEPART( WeeK, SYSDATETIME()) 'Current Week of the Year', CONVERT(VARCHAR(15), DATEADD(dd, -(DATEPART(dw, SYSDATETIME())-1), SYSDATETIME()),101) 'Start of Week Date', CONVERT(VARCHAR(15), DATEADD(dd, 7-(DATEPART(dw, SYSDATETIME())), SYSDATETIME()),101) 'End of Week Date'