<div>
Can you explain exactly what you're trying to do? &nbsp;None of the conditions are met, which is why it says false.
</div>


<div>
As Ron stated, none of the conditions are met. Using this formula, to get a 2, these 2 conditions must be met:<br><br>If 4/30/2021 is more than or equal to 5/4/2021 and 4/30/2021 is less than or equal to 4/28/20201 then 2.<br><br>Although the first condition is met, the second one is not.<br><br>Paul
</div>


Euro5

<div>
Four conditions:<br>1) IF(AND(I2=TODAY()-1,I2&lt;=TODAY()-7),4,<br>2) IF(AND(I2&gt;=TODAY()-8,I2&lt;=TODAY()-14),3,<br>3) IF(AND(I2&gt;=TODAY()-15,I2&lt;=TODAY()-21),2,<br>4) IF(AND(I2&gt;=TODAY()-22,I2&lt;=TODAY()-28)<br><br>Condition 1 can never happen, the Date cannot equal yesterday AND be earlier than one week prior<br>Condition 2 can never happen, later than today - 8 (last week) AND earlier than today -14 (two weeks ago)<br>Condition 3 can never happen, later than today - 15 (three weeks ago) AND earlier than today -21 (four weeks ago)<br>Condition 4 can never happen, later than four weeks ago AND earlier than five weeks ago.<br><br>You have the &gt;= and &lt;= the wrong way round, try:<br>=IF(I2="","",IF(AND(I2&lt;=TODAY()-1,I2&gt;=TODAY()-7),4,IF(AND(I2&lt;=TODAY()-8,I2&gt;=TODAY()-14),3,IF(AND(I2&lt;=TODAY()-15,I2&gt;=TODAY()-21),2,IF(AND(I2&lt;=TODAY()-22,I2&gt;=TODAY()-28),1)))))<br><br>1) Earlier than today-1 and later than today -7 (in previous week)<br>2) Earlier than today-8 and later than today -14 (two weeks ago)<br>3) Earlier than today-15 and later than today -21 (three weeks ago)<br>4) Earlier than today-22 and later than today -28 (four weeks ago) <br><br>What if the date is more than four weeks ago, you will still get a FALSE.
</div>


<div>
<div class="content wysiwyg-content fr-view">
I am using this formula today and the referenced date in I2 is 4/30/21, so the formula should say 2, but it says FALSE. Can anyone help?<br><br>=IF(I2="","",IF(AND(I2=TODAY()-1,I2&lt;=TODAY()-7),4,IF(AND(I2&gt;=TODAY()-8,I2&lt;=TODAY()-14),3,IF(AND(I2&gt;=TODAY()-15,I2&lt;=TODAY()-21),2,IF(AND(I2&gt;=TODAY()-22,I2&lt;=TODAY()-28),1)))))
</div>
</div>



I am using this formula today and the referenced date in I2 is 4/30/21, so the formula should say 2, but it says FALSE. Can anyone help?
=IF(I2="","",IF(AND(I2=TODAY()-1,I2<=TODAY()-7),4,IF(AND(I2>=TODAY()-8,I2<=TODAY()-14),3,IF(AND(I2>=TODAY()-15,I2<=TODAY()-21),2,IF(AND(I2>=TODAY()-22,I2<=TODAY()-28),1)))))

Excel formula for dates

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.