Identifying last 3 Business Days

[Tune]

Good Day everyone is there anyone that can help how I can determine if the current business day is included in the last 3 business days of the month excluding all holidays.

I just need a boolean output after the check. Right now im stuck on creating formula regading this scenario

TIA

[Qiu]

@Tune 

I would use the DateTimeTrim functio to get the last day of the month of your current business day.

Then generate back more 15 day, filter out the weekends.

[Tune]

Thank you for your help Qiu one more thing how can I remove a date if it's a holiday and get the next day instead of the holiday.

Ex. 

May 28 - (Get this date instead of the Holiday)

May 29 - Last 3 Business Day

May 30 - Holiday

May 31 - Last 3 Business Day

Result should be 31, 29 and 28 instead of 31, 30, 29

Thank you and looking forward to your response

[Qiu · Accepted solution]

@Tune 
We can have a list containing the holidays the filter them out.

[Tune]

Again Thank you so much