<div>
Instead of =COUNTIF(DATA,&quot;&lt;B2&quot;), use<br />
<br />
=COUNTIF(DATA,&quot;&lt;&quot; &amp;&nbsp;B2)
</div>


Instead of =COUNTIF(DATA,"<B2"), use

=COUNTIF(DATA,"<" & B2)

<div>
I've tried the as well Phillip. Same 0 results. Thanks.<br />
<br />
For the cells with or without &quot;FIT&quot;, that worked, Thank you!
</div>


I've tried the as well Phillip. Same 0 results. Thanks.

For the cells with or without "FIT", that worked, Thank you!

<div>
I think you need to post your spreadsheet.
</div>


I think you need to post your spreadsheet.

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
I really don't have much time to search for an answer here. Time crunch for my boss!<br />
I'm trying to count a range of dates using COUNTIF. The issue is I'm using dynamic data from two cells with the =TODAY()-30 and =TODAY() functions. <br />
<br />
Example: =COUNTIF(DATA,&quot;&lt;B2&quot;), DATA being my named range, I get a 0 in the cell. IF I use =COUNTIF((DATA,&quot;&lt;10/19/201<wbr />4&quot;) I'll get a good count.<br />
<br />
I'd also like to count a range of cells with &quot;FIT&quot; in it and cells that do not contain the word &quot;FIT&quot; in them.
</div>
</div>


Hi experts,

I really don't have much time to search for an answer here. Time crunch for my boss!
I'm trying to count a range of dates using COUNTIF. The issue is I'm using dynamic data from two cells with the =TODAY()-30 and =TODAY() functions. 

Example: =COUNTIF(DATA,"<B2"), DATA being my named range, I get a 0 in the cell. IF I use =COUNTIF((DATA,"<10/19/2014") I'll get a good count.

I'd also like to count a range of cells with "FIT" in it and cells that do not contain the word "FIT" in them.

COUNTIF with dates

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.