date Automation

Tinka Louw

I want to set up an workflow automation to look the last working day of a month. I use the sheet as an input sheet and to not want change the date of the trigger monthly. I do not see an option for last working day.

Please advise

Paul Newcome

Try putting this into a Date type column and then set your automation to run off of this column.

=WORKDAY(DATE(YEAR([Date Column]@row) + IF(MONTH([Date Column]@row) = 12, 1), IF(MONTH([Date Column]@row) = 12, 1, MONTH([Date Column]@row)), 1), -1)