I have a data where I need to find Saturday and Sunday in a row. If yes, to have a new column with 1 as yes and 0 as no.
I tried with number of days in a week but in the data we had some missing dates hence it didn't worked out and used multi row formula but also didn't worked.
Example:
Date | Check |
6/24/2021 | 0 |
6/25/2021 | 0 |
6/26/2021 | 1 |
6/28/2021 | 0 |
6/29/2021 | 0 |
6/30/2021 | 0 |
7/3/2021 | 1 |
7/4/2021 | 1 |
7/7/2021 | 0 |
7/8/2021 | 0 |
7/9/2021 | 0 |
Solved! Go to Solution.
Hi @PNC97
Sorry our bad i dont know how we missed this post. Response is posted on the below post.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/finding-Weekdays-in-month/td-p/801234
Hope this helps : )