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 |
