CountIf function + dates

P

patricia

Does this work with dates? I have a column of dates and
wanted to count the # of dates greater than or less than
todays date. I set the formula for =COUNTIF(C2:C21,">today
()")and it came back zero, I then changed the formula to <
today() and still zero. There are dates that are < and
 
D

Dave R.

Try this instead. The extra part is necessary to weed out blank cells which
have "dates of 0".

=SUMPRODUCT(--(C2:C21<TODAY())*(C2:C21<>""))
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
countifs Function not giving desired result with date criteria 2
Countif or other formula needed for multiple data/critera results 3
Show value from one cell in another cell if today falls between a date range 5
Conditional Formatting question.... 1
Using <= in countifs statement 1
Excel 2010 countifs for date range 3
Sumif Question 1

Top