HI All,
I am struggling a bit on calculating the dates for below scenario can some help me on this .
I have start date and end date and also the list of holidays. I need to check if my start date and end date falls in between holiday list, then I need to add no of holiday that falls in between start date and end date to end date (i.e., End date + no of holidays)
I tried this by applying generate rows formula to start and end date and join with holiday list to count no holidays and add back to end date. but this is tedious when we have huge set of data. is there any other workaround for this?
I have attached the Alteryx flow what I tried to achieve.
Data:
| Project | Start Date | End Date |
| A | 11/2/2020 | 11/20/2020 |
| B | 11/9/2020 | 11/27/2020 |
| C | 11/9/2020 | 11/27/2020 |
| D | 11/9/2020 | 11/27/2020 |
| E | 11/16/2020 | 12/4/2020 |
| F | 11/16/2020 | 12/4/2020 |
| G | 11/16/2020 | 12/4/2020 |
| H | 11/16/2020 | 12/4/2020 |
| I | 11/16/2020 | 12/4/2020 |
| J | 11/23/2020 | 12/11/2020 |
| K | 11/23/2020 | 12/11/2020 |
| L | 11/23/2020 | 12/11/2020 |
Holiday List:
| Date |
| 1/1/2021 |
| 2/11/2020 |
| 2/12/2020 |
| 2/13/2020 |
| 2/14/2020 |
| 2/15/2020 |
| 2/16/2020 |
| 2/17/2020 |
| 2/18/2020 |
| 4/4/2021 |
| 5/1/2021 |
| 6/14/2021 |
| 9/21/2021 |
| 10/1/2021 |
| 10/2/2021 |
| 10/3/2021 |
| 10/4/2021 |
| 10/5/2021 |
| 10/6/2021 |
| 10/7/2021 |
| 11/5/2020 |
| 11/6/2020 |
| 11/7/2020 |
| 11/8/2020 |
| 11/9/2020 |
