Help with a simply IF formula

Question

Hello!
I have been stuck on this problem for HOURS. Please help :'(

I have a check box that I would like CHECKED when:

Referenced Date Field is after January 1, 2024

All days before 1/1/24 is UNCHECKED

It has been at least 7 days since Referenced Date Field

If Referenced Date Field = 2/1/24, then it's checked if TODAY() = 2/8/24&nbsp;

Here is the formula I have. The +7 days portion works but the before 1/1/24 doesn't work :(

If([Date Field] + Days(7) &lt;= Today()
and
[Date Field] &gt; ToDate(01/01/2024),
true, false)

Thank you in advance if you are able to help me solve------------------------------Kim Anh Nguyen------------------------------

chayceduncan · Answer

If I'm understanding correctly you just need to make sure that anything before 1/1/24 is unchecked? You can do a condition that specifically calls that out like so if that's what you need:&nbsp;&nbsp;
if(&nbsp;
&nbsp; &nbsp; &nbsp;[Date Field] &lt; ToDate("1/1/24"), false,
&nbsp; &nbsp; &nbsp;[Date Field] + Days(7) &lt;= Today(), true,
false)
------------------------------Chayce Duncan------------------------------

kimnguyen · Answer

Thank you SOOOOOOO much!!!------------------------------Kim Anh Nguyen------------------------------

Forum Discussion

Help with a simply IF formula