Essentially, I'm trying to replicate the NETWORKDAYS function from Excel. Below is an example of the two columns and expected results. For this example, the time frame is April - June, where 5/27/24 and 6/19/24 are both Holidays. I should also note that the RECEIPT_DT is technically day 0.
| RECEIPT_DT | FD_DATE | Expected Delta (Days) |
| 4/3/24 | 4/3/24 | 0 |
| 5/17/24 | 5/20/24 | 1 |
| 5/1/24 | 5/3/24 | 2 |
| 5/24/24 | 5/29/24 | 2 |
My current approach has been adding an "input" to my Workflow followed by a "formula" and using ChatGPT to write the code. I'm able to get it working but can't seem to solve the Holiday part. For example, in the last row of my table, the result I keep getting is 4 days.
Please let me know if I can provide any additional information. Thank you!
