Business Day Logic

[Gandalf_NotGrey]

Hello, I have a query related to Date and Time.

I have a SQL query which tells me which Business Day (BD) of the month it is today. If today is October 4th 2024, it will give the result as 4, meaning that today is the 4th Business Day of October 2024. This SQL query pulls data from a source table which is based on US Fed Reserve Holidays and BDs are calculated accordingly. I have attached an excel file with the list of Business Days for ease of use.

Now, this workflow runs every day and I want that if today is Saturday or Sunday or a Holiday then it should be give me the output of previous BD and in case the previous BD is not in the current month but in the previous month, then in that case it should be give me the output as 1.

[OTrieger]

@Gandalf_NotGrey 
You will manage to do it with a Multi Row Formula tool.

[binuacs · Accepted solution]

@Gandalf_NotGrey Sample workflow attached