Here's one way:

CREATE FUNCTION [dbo].[IF_Calendar]

(

@StartDate DATE,

@EndDate DATE,

@FirstWeekDay VARCHAR(10)

)

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

(

-- inline tally table

WITH E1(N) AS (

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1

), --10E+1 or 10 rows

E2(N) AS (SELECT 1 FROM E1 a CROSS JOIN E1 b), --10E+2 or 100 rows

E3(N) AS (SELECT 1 FROM E2 a CROSS JOIN E2 b), --10E+4 or 10,000 rows max

iTally AS ( -- generate sufficient rows to cover startdate to enddate inclusive

SELECT TOP(1+DATEDIFF(DAY,@StartDate,@EndDate))

rn = ROW_NUMBER() OVER(ORDER BY (SELECT NULL))-1

FROM E3

)

-- Do some date arithmetic

SELECT

a.DateRange,

c.[Year],

c.[Month],

c.[DayOfMonth],

c.AbsWeekno,

c.[DayName],

d.Holiday

FROM iTally

CROSS APPLY (SELECT DateRange = DATEADD(day,rn,@StartDate)) a

CROSS APPLY (VALUES ('Tuesday',1),('Wednesday',2),('Thursday',3),('Friday',4),('Saturday',5),('Sunday',6),('Monday',7)

) b (FirstWeekDay, FirstWeekdayOffset)

CROSS APPLY (

SELECT

[Year] = YEAR(a.DateRange),

[Month] = MONTH(a.DateRange),

[DayOfMonth] = DAY(a.DateRange),

AbsWeekno= DATEDIFF(day,FirstWeekdayOffset,a.DateRange)/7,

[DayName]= DATENAME(weekday,a.DateRange)

) c

CROSS APPLY (

SELECT Holiday = CASE

WHEN [Month] = 1 AND [DayOfMonth] = 1 THEN 'New Year'

WHEN [Month] = 5 AND [DayOfMonth] >= 25 AND [DayName] = 'Monday' THEN 'Memorial Day'

WHEN [Month] = 7 AND [DayOfMonth] = 4 THEN 'Independence Day'

WHEN [Month] = 9 AND [DayOfMonth] <= 7 AND [DayName] = 'Monday' THEN 'Labor Day'

WHEN [Month] = 11 AND [DayOfMonth] BETWEEN 22 AND 28 AND [DayName] = 'Thursday' THEN 'Thanksgiving Day'

WHEN [Month] = 12 AND [DayOfMonth] = 25 THEN 'Christmas Day'

ELSE NULL END

) d

WHERE b.FirstWeekDay = @FirstWeekDay

)