Countif function

B

Bob

Good morning, I have a column with dates (MM/DD/YY) and I'm trying to write a
formula that will look at this column and tell me which ones are older than
today. I tried =COUNTIF(B11:B396, "<TODAY()") which did not work. The only
way I could get a result was =COUNTIF(B11:B396, "<01/19/10"). The problem
with this is you have to enter today's date each time you open the file. Is
there not an easier solution?
 
M

Ms-Exl-Learner

Use your formula like this...

=COUNTIF(B11:B396,"<"&TODAY())

Remember to Click Yes, if this post helps!
 
D

David Biddulph

=COUNTIF(B11:B396, "<TODAY()") is looking for the text string "<TODAY()"
Try =COUNTIF(B11:B396, "<"&TODAY())
 

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

possible countif formula? 3
Countif if counted results are based on formula 6
Excel function - countif 2
COUNTIF for numbers of dates in column which are 30 days older than today 6
How can I check whether a column of dates are all before today's d 3
Countif Function Using "AND" 3
Countif versus SumProduct 3
countif using other cell values for 'range' and 'criteria' 4

Top