Calculate date excluding weekends and holidays

Question

I am trying to figure out how to calculate what the date will be a specified number of days after a provided date, while excluding both weekends and holidays.  For instance if the closing date was 2025-06-04 then the date available for QC (the columns from my file) should be 2025-06-20.  I have attached a file showing the closing date as well as the desired outcome based on the calculations that the end user provided.

QC Date Examples.xlsx

MattR79 · Answer

It looks like the calculation is working and giving me the right date, but only for items that were closed on 2025-06-02, because in the final filter there is a formula that only keeps items where the record ID equals the days to add on +1.  I need the workflow to give me the date for all of the records with a closing date in the file.  Based on what is in the file there should be a date for 02 to 09 June, as shown below.

Closing DateDate available for QC (Desired Result)6/2/20256/17/20256/3/20256/18/20256/4/20256/20/20256/5/20256/23/20256/6/20256/24/20256/9/20256/25/2025

Pilsner · Answer

Hello @MattR79

I've added a join tool, which joins on closing data, which should allow for the number of rows to be matched. I've also unioned on all the empty records so that the record count matches exactly.

I've attached the updated workflow below, please let me know how you get on.

Regards - Pilsner

New Workflow2.yxmd

MattR79 · Answer

Thank you, but this doesn't quite seem to be doing what I need, as I would expect to see as many rows in the browse tool as are coming in from the file, but there is only one record coming out due to the last filter, which is only giving the record where the ID matches the number of days to add on.  I also had some questions about why certain things were done, for example in the Formula tool right after the generate rows tool, you have it adding the row count versus the days to add on, with that none of the dates match.  I made some changes and have separated the original results and what I got with my changes.  I was able to get some to match up but not all, and I'm unsure as to why.  I think it might have something to do with the generate rows tool, but I'm not familiar enough with that to be sure.

Available for QC.yxzp