How to find weekends in a week

[PNC97]

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

[atcodedog05 · Accepted 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 : )