DECLARE @intEmployeeCode INT = 2309
DECLARE @StartDate datetime;
DECLARE @EndDate datetime;

DECLARE @Month int
DECLARE @Year int

SET @Month = month(getdate())
SET @Year = year(getdate())

SET @StartDate = (select DATEADD(month,month(getdate())-1,DATEADD(year,year(getdate())-1900,0)) ) /*First*/
SET @EndDate = (select DATEADD(day,-1,DATEADD(month,@Month,DATEADD(year,@Year-1900,0))) )/*Last*/


;WITH cte AS (
    SELECT
    CAST(CAST (@StartDate AS NVARCHAR) AS date) AS myDate
    UNION ALL
    SELECT DATEADD(day,1,myDate) as myDate

    FROM cte
    WHERE DATEADD(day,1,myDate) <= CAST(CAST (@EndDate AS NVARCHAR) AS date))

SELECT myDate ,datename(dw,myDate) AS DayOfDate
FROM cte
WHERE datename(dw,myDate) <> 'Sunday'
OPTION (MAXRECURSION 0);

Week Number  Working Days
Week 1       5
Week 2       6
Week 3       6
Week 4       6
Week 5       4