Need formula that will count the number of dates older than today

C

CW

Hello!

Say today's date is 5/1/2007 and I have a column with dates that looks
like this:

DATE
4/27/2007
4/29/2007
4/30/2007
5/1/2007
5/2/2007
5/3/2007

I need a formula that will count the number of dates that are older
than today. For instance, for this list, the formula will output the
number 3.

I've tried COUNTIF and DCOUNT and I couldn't get either to work.

Any idea? Thanks.

-Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to count number of dates older than today 6
Excel Formula - Count Dates from another Sheet 8
Count Unique Cells, within a date range (dates stored in separatecolumn). 3
Formula to count number of days that match, when comparing one daterange to another 3
need to compare dates and count the results 2
Numbering Trading days per month from a list of Dates 3
Excel How to calculate in excel number of open actions that expired (older then today) 0
Count number of cells containing a specific date range 7

Top