I am trying to query my table for records where a date field is between 10 Business Days ago and Today. I am struggling to calculate the date 10 business days ago. 

In my case, Holidays don't matter. I only need to include Monday - Friday regardless of holiday / working day. 

I found this SQL code which does what I want, but backwards. This calculates the number of business days between two dates and I need to subtract a number and get to a date. 

```
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @StartDate = '2019-08-26'
SET @EndDate = GETDATE()

SELECT
   (DATEDIFF(dd, @StartDate, @EndDate) + 1)
  -(DATEDIFF(wk, @StartDate, @EndDate) * 2)
  -(CASE WHEN DATENAME(dw, @StartDate) = 'Sunday' THEN 1 ELSE 0 END)
  -(CASE WHEN DATENAME(dw, @EndDate) = 'Saturday' THEN 1 ELSE 0 END)

```

I've tried using `DATEADD` but can't figure out any logic to exclude Saturday and Sunday. I also don't want to use a function is I don't absolutely have to. I have not been able to find anything regarding DATEADD online without a function that loops through each day.

Desired Functionality:

```
START DATE: TODAY / GETDATE()
NUMBER OF BUSINESS DAYS: 10

DATEADD(DAY, -10 + CALULATE WEEKEND DAYS?, GETDATE())

```