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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cachod1 - 27 Jan 2006 22:59 GMT

I need to count the number of cells within a column that contain a date that
is less than/equal to today's date. What formula can I use to do this?

Reply to this Message

Elkar - 27 Jan 2006 23:23 GMT

Try this:

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

HTH,
Elkar

> I need to count the number of cells within a column that contain a date that
> is less than/equal to today's date. What formula can I use to do this?

Reply to this Message

Anne Troy - 27 Jan 2006 23:24 GMT

This is the 3rd time you have asked the same question. What is wrong with
the answers you're receiving?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

>I need to count the number of cells within a column that contain a date
>that
> is less than/equal to today's date. What formula can I use to do this?

Reply to this Message