+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Cachod1
    Guest

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

    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?

  2. #2
    Elkar
    Guest

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

    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?


  3. #3
    Anne Troy
    Guest

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

    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?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1