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?
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?
Try this:
=COUNTIF(A1:A100,"<="&TODAY())
HTH,
Elkar
"Cachod1" wrote:
> 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?
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
"Cachod1" <Cachod1@discussions.microsoft.com> wrote in message
news:8A3DF11B-E467-4205-91AB-76CB986BA836@microsoft.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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks