Figure out date difference in SQL Server

[x_Master_x]

You need to combine two DATEDIFF (https://learn.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver16). One for know who many week is passed between two dates (wk paramenter) and one for get the days between two date (dd parameter). Subtract number of weeks to the difference in days for remove sundays.