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
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 contained
Thursdaywould instead report
FALSEwhen comparing to
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, Fand another adjacent column containing "definitions" (i.e.,
Monday, Tuesday, Wednesday, Thursday, Friday) to refer back to.