Dynamic input to contain business day

janani_venkat

Hi!

I am trying to build a dynamic input path using formula but cannot figure out how to add business day - basically, if I run the file end of last week, I need to pick a file with WD15 in the input file path. How do I do that?

Attached is my workflow - can you please tell me if this possible?

Expected path from my workflow:

C:\Users\JV\2021\012021\Data Dump\Data WD 15 cut.xlsx

Dynamic input.yxmd

danilang

Hi @janani_venkat 

Any discussion of business days needs to consider holidays.  For instance, in Canada, Feb 15 is Family Day and must be removed from the list of business days.  The easiest way to do that have a list of holidays and join this to the generated list of days in the month, taking the L output.  Starting from @ddiesel's excellent solution, here's a modification that takes holidays into account

 

Holiday's come in 2 types, static i.e. New Year's Day which is always Jan-01, and dynamic ones, like Family Day which is the 3rd Monday in February.  The static ones can be handled easily with a text box that holds the month and day for the holiday, "-01-01" and a Formula that prepends the current year. 

The dynamic ones are trickier and need to be handled on a case by case basis.  The 3rd Monday of any month will always be between 15th and the 21st, so generate all these dates and take the one that is a Monday.  Union this with the static holiday list and join to the list of dates generated for the current month.  The join is used as a filter to exclude the holidays, so use the L to get the days that don't match.

Dan

Dynamic input to contain business day(Holidays).yxmd