Hi I want the previous business day and previous business day -1 below are the examples
| Today's date | previous date | Previous date -1 |
| 2021/11/29 | 2021/11/26 | 2021/11/24 |
| 2021/11/23 | 2021/11/22 | 2021/11/19 |
| 2021/11/15 | 2021/11/12 | 2021/11/11 |
In the first example, 29th Nov was Monday and 26th was Friday but I did not pick 2021/11/25 because it was thanksgiving. Basically, I have a list of dates that holidays and should be excluded from the previous date column and Previous date -1 column as well
Note: If holiday value comes pick one day before for both the column
Holiday-2021/11/25