Check Weekdays (3 days in a row)

[dhana_ram]

Hi All,

Please I need help :D
I want to know which record has a >=3 days in a row in weekdays (saturday and sunday is not count)

For example:
Apple - they had a stamp date 3 days in a row (thursday, friday, monday) = Clear.
Pineapple - they had a stamp date >3 days but only 09 - 11 Feb that are consecutive days = So I need to remove 15 Feb.

Any ideas on how to identify which item that has a stamp date in consecutive days?

Thank you,

 

[BSALV]

Map1
	A	B	C
1	datums	fruit	3Cons
2	zo 27/02/2022	apple	0
3	ma 28/02/2022	apple	1
4	di 01/03/2022	apple	1
5	wo 02/03/2022	apple	1
6	do 03/03/2022	apple	1
7	vr 04/03/2022	apple	1
8	za 05/03/2022	apple	0
9	zo 06/03/2022	apple	0
10	ma 07/03/2022	apple	0
11	di 08/03/2022	banaan	0
12	wo 09/03/2022	apple	1
13	do 10/03/2022	apple	1
14	vr 11/03/2022	apple	1
15	za 12/03/2022	apple	0
16	zo 13/03/2022	apple	0
17	ma 14/03/2022	apple	1
18	di 15/03/2022	apple	1
19	wo 16/03/2022	apple	1
20	do 17/03/2022	apple	1
21	vr 18/03/2022	apple	1
22	za 19/03/2022	apple	0
23	zo 20/03/2022	apple	0
Blad1

Cell Formulas
Range	Formula
C2:C23	C2	=(LEN(SUBSTITUTE(TEXTJOIN("",,IF((COUNTIFS([datums],[@datums]+SEQUENCE(5,,-2),[fruit],[@fruit])>0)*(WEEKDAY([@datums]+SEQUENCE(5,,-2),2)<=5),"1","0")),"111",""))<5)+0

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C23	Expression	=$C2=1	text	NO