Checking a box if current month

LisakayS

Hello,

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?

Thank you,

Lisakay

Chris Shifflett

=IF(MONTH([Next MI Date])=MONTH(TODAY()),TRUE,FALSE)

It is possible that the date format of the "Next MI Date" column is incorrect, which is causing the formula to not work as expected. To resolve this issue, you can change the date format of the "Next MI Date" column to "MM/DD/YYYY".