How to identify Business Day FROM and BEFORE a certain date

Question

Hello,

Hope everyone is doing great. Appreciate if someone can help me in determining the formula or workflow on how to identify the 10th Business Day FROM and BEFORE a certain date. I have attached the sample data for reference.

Sat, sun and US holidays should be excluded from the count of days.

Thank you so much.

Pawee

Bren_Spill2 · Accepted Answer

@PaweeArce - check out this link: Alteryx for Excel Users: Find the future date after 'x' working days from [Date]

apathetichell · Accepted Answer

An alternative idea--> add a recordid to the calendar which separates out holidays/weekends.

join schedule -> calendar. select "deselect duplicate fields"

subtract your value from recordid (like recorid-10 or whatever) as a new value called -> startvalue

join on itself startvalue on recordid. do not deselect duplicate fields.

your new datasource will be original date, recordid of the original date from the calendar. start value (ie record id-10), Right_original date. Right_original date (or original date- depending upon how you structure your join) will now be the date-10. rename the date fields to refelct proper naming in a select tool.