'How can I output the values I want by using TEXT() version of TODAY() and FIND() in an IF() formula?
I would like to output "Yes" or "" in column B by using the text version of today's date (e.g. Fri) and finding Fri in column A with values like Tue, Fri, Sun in them, then making sure that the date today matches the value in that cell within column A before it outputs "Yes".
I'm probably using FIND wrong in this formula I made but I cannot figure out how to use it in a way that it would not give me an error.
Hopefully, someone can help me figure out what I am getting wrong or if I am overcomplicating this.
The formula I used: =IF((TEXT(TODAY(),"ddd")=FIND((TEXT(TODAY(),"ddd"),A:A))),"Yes","")
What it looks like:
Example: Google Sheet
Solution 1:[1]
use:
=INDEX(IF(A2:A="",,IF(REGEXMATCH(A2:A, TEXT(TODAY(), "ddd")), "Yes", "No")))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |