Return a previous date (exclude saturday, sunday and holiday) in sql

I want to create store procedure that will return a previous date (exclude saturday, sunday and holiday)
Holiday's list in a table called 'tblHoliday'
I have below that returns only previous business day

declare @dtDate varchar(12)
set @dtDate = GETDATE()
declare @strPrevNext varchar(12)
set @strPrevNext = 'Previous'


DECLARE @intDay INT
DECLARE @rtResult DATETIME
SET @intDay = DATEPART(weekday,@dtDate)
--To find Previous working day
IF @strPrevNext = 'Previous'
IF @intDay = 1
SET @rtResult = DATEADD(d,-2,@dtDate)
ELSE
IF @intDay = 2
SET @rtResult = DATEADD(d,-3,@dtDate)
ELSE
SET @rtResult = DATEADD(d,-1,@dtDate)
--To find Next working day
ELSE
IF @strPrevNext = 'Next'
IF @intDay = 6
SET @rtResult = DATEADD(d,3,@dtDate)
ELSE
IF @intDay = 7
SET @rtResult = DATEADD(d,2,@dtDate)
ELSE
SET @rtResult = DATEADD(d,1,@dtDate)
--Default case returns date passed to function
ELSE
SET @rtResult = @dtDate
--RETURN @rtResult

print @rtResult