Understanding the Peculiar Behavior of SQL Server's DATEDIFF Function When Used with DATEADD

How to Modify DATEDIFF Function in SQL Server to Exclude Specific Days of the Week from Calculations