The input is an array [Tuesday, Wednesday] but it is should be stored in one cell only. Using this input I want to know how many days between two dates.

I found a reference but I don't know how to make it as dynamic because it only accept integer weekday.

CodePudding user response：

use:

=SUMPRODUCT(REGEXMATCH(TEXT(SEQUENCE(DAYS(B2, B1) 1, 1, B1), 
 "dddd"), REGEXREPLACE(A4, ", ?", "|")))