MS Excel formula question?

My business is making a spread sheet for our Army Pre-book unit.To account for when people have flushed their renewal/re-certify night out on distinct training I want to spot a system (like a COUNTIF) at the end of the actual column connected with dates.The formula would have to count the number of cells who have a time frame past right now.So the item one person was caused by re-certify this morning, and another patient was caused by re-certify continue month it will return some sort of value with two.

I’d regards if you can actually point me inside right direction.

Assuming your column of dates is definitely column A, cells A1:A100, take advantage of this formula inside the cell of this choice.

=SUMPRODUCT((A1:A100<TODAY())* (A1:A100″”))

When you have more than 100 rows, enhance the ‘100’ cost.

Or feel free to use:

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

Revise:Note which the Sumproduct purpose cannot parse ‘column type’ ranges including ‘A:A’.