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" <[email protected]> wrote in message
news:[email protected]...
>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