How Do I Remove Public Holidays in a Date Range – Design

Answer

Create a table with public days details and use them in the query to exclude those days from a date range.

For Example:

select count(*) from xx_publicHolidays where (date, between @startdate and @ endDate)

Date in the where condition is the column name in the table.