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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cachod1 - 27 Jan 2006 18:27 GMT

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!

Reply to this Message

JMB - 27 Jan 2006 18:33 GMT

If the data is in cells A1:A3

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

> 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!

Reply to this Message

CLR - 27 Jan 2006 19:32 GMT

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

Vaya con Dios,
Chuck, CABGx3

> If the data is in cells A1:A3
>
[quoted text clipped - 3 lines]
> > <= today's date. I've tried using a COUNTIF formula but it's not working.
> > HELP!

Reply to this Message

Bob Phillips - 27 Jan 2006 21:14 GMT

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> 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!

Reply to this Message