A long-time reader sent me an interesting problem this past week.
The problem is that the weekdays are input as yes/no abbreviations like “NYNYNYN” for “MWF”.
Note: you are free touse line breaksinside the formula bar to make formulas easier to read.
Option #2- TEXTJOIN and MID function:
This solution usesarray constantsto simply the formula considerably.