Count number of cells with date <today's date
=COUNTIF(B1:B100,"<"&TODAY())
Bb Umlas
Excel MVP
"Cachod1" wrote in message
...
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"
|