formula that checks if a project happened during the current month
I'm trying to create a formula that checks if a project happened during the current month.
Project Start: 09/09/19 | Project Finish: 12/13/19
Here is what I have that kind of works: =IF(AND(TODAY() >= Start@row, TODAY() <= Finish@row), 1, 0)
However, this formula does not work if the project happened during the current month, but the finish date is prior than the current day.
Example: Today's date is 11/19/19
Project Start: 11/01/19 | Project Finish: 11/12/19
This will not check the box.
So I need a formula that will check the box if at any point in the date range, it is the current month.
Help Article Resources
Check out the Formula Handbook template!