VB.NET - query

when i Store All government holidays from table ....... so when i given the from date and todate so here it will not counting this days so how to do that please

Get the count by checking the dates in the holidays range


DECLARE @startDate DATETIME
DECLARE @endDate DATETIME

--Assign values here
SELECT COUNT(1) FROM tblHolidays WHERE dtHoliday BETWEEN @startDate AND @endDate
--This gives you the count for number of holidays present in the holiday list substract the number from the total number of days in the above range

Thanks