software

I need to count the number of cells in one column that contain a date that is
lt;= today's date. The dates are currently formatted as quot;Generalquot; numbers
rather than being formatted as quot;Datequot;

=COUNTIF(B1:B100,quot;lt;quot;amp;TODAY())
Bb Umlas
Excel MVP
quot;Cachod1quot; gt; wrote in message
...
gt; I need to count the number of cells in one column that contain a date that
is
gt; lt;= today's date. The dates are currently formatted as quot;Generalquot; numbers
gt; rather than being formatted as quot;Datequot;
Which of the four responses you've received thus far don't work???????????

quot;Cachod1quot; wrote:

gt; I need to count the number of cells in one column that contain a date that is
gt; lt;= today's date. The dates are currently formatted as quot;Generalquot; numbers
gt; rather than being formatted as quot;Datequot;