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

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