count the number of cells with a date <= today's date
 

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!

count the number of cells with a date <= today's date
 

If the data is in cells A1:A3

=COUNTIF(A1:A3, "<="&TODAY())

"Cachod1" wrote:

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!

count the number of cells with a date <= today's date
 

This formula will also count any other number that is NOT a date, as though
it WAS a date............

Vaya con Dios,
Chuck, CABGx3



"JMB" wrote:

If the data is in cells A1:A3

=COUNTIF(A1:A3, "<="&TODAY())

"Cachod1" wrote:

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!

count the number of cells with a date <= today's date
 

=SUMPRODUCT(--(A2:A200<""),--(A2:A200<=TODAY()))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Cachod1" wrote in message
...
I need to count the number of cells in a column that contain a date that
is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!