title: Excel Formula that identify whether a date is in the list of dates
body: <p>I have a list of dates in Excel :</p>
  <pre><code>22/07/2022, 23/08/2022, 24/09/2022
  </code></pre>
  <p>I want to identify whether a specific date (current date) is in the list of dates. (E.g. 24/09/2022)</p>
  <p>What formula shall I use ?</p>
  <p>I tried  the formula below, but it doesn't work. It gives inaccurate results.</p>
  <pre><code>(COUNTIF([Future Assumptions].[Dummy Values], Today()) &gt; 0) 
  </code></pre>
  <p>Note :</p>
  <p><code>[Future Assumptions].[Dummy Values]</code> returns a list of dates.</p>
  <p>UPDATE 1:</p>
  <p><code>[Future Assumptions].[Dummy Values]</code> has values :</p>
  <pre><code>6/30/2025
  12/30/1899
  12/30/1899
  6/30/2026
  12/30/1899
  12/30/1899
  12/30/1899
  3/31/2024
  6/30/2026
  12/29/1905
  12/20/2031
  12/30/1899
  11/17/2025
  12/30/1899
  12/30/1899
  10/30/2025
  12/30/1899
  12/30/1899
  3/30/2024
  5/30/2025
  7/14/2028
  12/30/1899
  12/31/2022
  12/30/1899
  7/18/2028
  1/31/2026
  8/14/2025
  3/30/2028
  12/30/1899
  10/30/2025
  
  (COUNTIF([Future Assumptions].[Dummy Values].List(), 12/70/1990) &gt; 0)
  </code></pre>
  <p>It always returns <code>1</code> even if the value '12/70/1990' is not in the list.</p>