Identifying last 3 Business Days

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

Developer

Google Analytics

Accepted answers

Qiu

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

0510-Tune-r1.yxzp

All comments

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.

0510-Tune.yxzp

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

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

0510-Tune-r1.yxzp

Tune

Again Thank you so much

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703