Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
hamrogers
Lv 6
hamrogers asked in Computers & InternetProgramming & Design · 1 decade ago

MS Excel formula question?

I am making a spread sheet for my Army Reserve unit. To keep track of when people have passed their renewal/re-certify date on specific training I would like to place a formula (like a COUNTIF) at the bottom of the column of dates. The formula would have to be able to count the number of cells that have a date past today. So it one person was due to re-certify last week, and another person was due to re-certify last month it would return a value of two.

I'd appreciate it if you could point me in the right direction.

1 Answer

Relevance
  • garbo7441
    Lv 7
    1 decade ago
    Favorite Answer

    Assuming your column of dates is column A, cells A1:A100, use this formula in the cell of your choice.

    =SUMPRODUCT((A1:A100<TODAY())* (A1:A100<>""))

    If you have more than 100 rows, increase the '100' value.

    Or you can use:

    =COUNTIF(A:A,"<" &TODAY())

    Edit: Note that the Sumproduct function cannot parse 'column type' ranges such as 'A:A'.

Still have questions? Get your answers by asking now.