I know I'm very close with my formula:
=IF(SEARCH("Wednesday", (A3:A)), "workday", 0),
But I must be missing something here...: I can't get this formula to display the value "-" when I run it on a cell that is False. (I'm trying to paste this formula on every row to have a quick visual reference for whether or not that day was a workday. Currently my days off are Wednesday and Friday.)
Would anyone help me understand where this formula needs to be corrected?
P.S. I did look a little bit of searching on this website for about five minutes; is that enough time to warrant asking this question? I have also provided a visual reference to the Sheet itself.
Google sheets is so powerful, I had no idea. Fun to be learning this.
Formula that doesn't work as expected:
=IF(SEARCH("Wednesday", (A3:A)), "workday", "-")