Checking a box if current month
I am trying to check a box if the "Next MI Date" is equal to the current month. Here's the formula I have but even when the "Next MI Date" is 02/01/2023 it is not checking the box.
=IFERROR(IF(MONTH(TODAY()) = MONTH([Next MI Date]@row), IF(YEAR(TODAY()) = YEAR([Next MI Date]@row), 1, 0)), 0)
What am I missing?
Help Article Resources
Check out the Formula Handbook template!