With this :

```
Declare @MyDate Date
Set @MyDate = '2017-08-12'

```

I would like to get a table like this:

> 
> Where the Non Business days are replaced by the nearest Monday
> 
> 
> 

I have a Table called **Holidays** that have only the Dates that I consider non-business. Thank you for your help.

```
DateID    Date
1       2016-08-12
2       2015-08-12
3       2014-08-12
4       2013-08-12
5       2012-08-13
6       2011-08-12
7       2010-08-12
8       2009-08-12
9       2008-08-12
10      2007-08-13

```

Here is Holiday Table to be considered like a Saturday or a Sunday

`Holbiz
2016-01-01
2016-02-15
2016-05-30
2016-08-12`
 2016-08-12 is only for the sake of this example