Hello,
I need to find missing the missing dates which excludes the weekends (Sat and Sun).
For Example,
| Acc Date | Process Date |
| 01/01/2024 | 01/02/2024 |
| 01/02/2024 | 01/03/2024 |
| 01/03/2024 | 01/04/2024 |
| 01/05/2024 | 01/06/2024 |
| 01/08/2024 | 01/09/2024 |
01/09/2024 | 01/10/2024 |
01/11/2024 | 01/12/2024 |
As the above example contains the date for January 2024,
As the weekend dates are not included, the missing dates are 01/04/2024 and 01/10/2024.
I want Alteryx workflow to give me the result as missing dates 01/04/2024 and 01/10/2024
The above example are for every day dates.
I also need to find the missing dates for the dates that comes in twice a week.
For Example,
Dates only comes in Wednesday and Thursday.
| Acc Date | Process Date |
| 01/03/2024 | 01/04/2024 |
| 01/04/2024 | 01/05/2024 |
| 01/10/2024 | 01/11/2024 |
| 01/11/2024 | 01/12/2024 |
| 01/18/2024 | 01/19/2024 |
| 01/24/2024 | 01/25/2024 |
| 01/25/2024 | 01/26/2024 |
So in above example, The dates only comes on Wed and Thru, and the missing date is 01/17/2024.
I want Alteryx workflow to give the result as missing dates 01/17/2024.
