Previous Business day and a day before

[sourabhsahu94]

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 

[Sebastiaandb]

Hi @sourabhsahu94 ,

Here you go, this should work for you, just alter the table with holidays to your liking :-).

Greetings,

Seb