Last Business day of the month

1

Hello guys,

Any idea on how to get the last business day of the month?
The idea is to create a parameter with this formula.

Thanks in advance
Best regards

2

The idea is to get the last three days of the month and see if they fall on a weekend. Out of 3, at least 1 should be a workday.

LET date = monthend(today())
LET last = when(not isweekend(date), date)
LET last_1 = when(not isweekend(date-1), date-1)
LET last_2 = when(not isweekend(date-2), date-2)
coalesce(last, last_1, last_2)
3

Thank you for your help.
Exactly what I need.

Regards