I created a schedule of events in Google Sheets.
- I have a cell that contains
MWF
, indicating that the event is every Monday, Wednesday, and Friday. - I have a different cell that reports the word
Monday
.
I'd like to determine if my two events overlap.
In other words, I need to determine if Monday
from the 2nd cell is included in MWF
from the first cell.
- In this case, the result I want would report
TRUE
, while an alternative scenario in which the 2nd cell containedThursday
would instead reportFALSE
when comparing toMWF
.
Visual example:
Is there a way I can do this without adding a separate region of a spreadsheet to define these letters?
- Ex: I don't want to add a column with
M, T, W, H, F
and another adjacent column containing "definitions" (i.e.,Monday, Tuesday, Wednesday, Thursday, Friday
) to refer back to.