Count number of cells with date <today's date

[Cachod1]

I need to count the number of cells in one column that contain a date that is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"

[Bob Umlas]

=COUNTIF(B1:B100,"<"&TODAY())
Bb Umlas
Excel MVP
"Cachod1" <[email protected]> wrote in message
news:[email protected]...
> I need to count the number of cells in one column that contain a date that
is
> <= today's date. The dates are currently formatted as "General" numbers
> rather than being formatted as "Date"

[JMB]

Which of the four responses you've received thus far don't work???????????

"Cachod1" wrote:

> I need to count the number of cells in one column that contain a date that is
> <= today's date. The dates are currently formatted as "General" numbers
> rather than being formatted as "Date"