Last working day of the month

Showcase Tips and Hacks
1

Hi,

here is a little formula to now if today is the last working day of the month

In section If of Automation:

Month(Workday(Today(), 1)) != Month(Today())

In Formula:
If(Month(Workday(Today(), 1)) != Month(Today()),"True", "False")

Obviously you should add an array of holidays to be more accurate (third parameter of Workday)

Cheers!

2 Likes