How to setup workflow to calculate aging minus weekends and holidays

Question

I am trying to setup a workflow to calculate aging between the date a case was opened and the date a case was closed less the weekend days (Saturday and Sunday) and Holidays.  I have the holidays set in a separate file.  The calculation that would be needed for Aging is to calculate the number of days between creation date and closed date, less the weekend days and holidays.  I am attaching some sample files to hopefully help you guys understand my ask.

I have been working to setup a workflow for this and keep running into issues.  Any help you can provide will be greatly appreciated.

Aging Sample.xlsx

Holiday Help.xlsx

gabrielvilella · Answer

The date format on the main table needed to be converted to an actual date type. I changed it on the Multi field formula.

Enwisen Quarterly Reporting Workflow.yxmd

ebowlan · Answer

Thank you all for your help.  I have put together a sample workflow based on the info above.  I keep getting an error message, so I am sure I have missed a step.  Would you be able to review and let me know what I am missing?

Sample Output - Alteryx.xlsx

Holiday and Tier 1.xlsx

Enwisen Quarterly Reporting Workflow.yxmd

atcodedog05 · Answer

Hi @ebowlan

Here is a zipped version of @gabrielvilella workflow

Hope this helps : )

Date count.zip