=COUNTIF formula

B

Bob

I have a cloumn of dates and want to enter a formula that will tell how dates
are older than today. I tried =COUNTIF(F11:F369, "<TODAY()") with no sucess.
The best I could get was using the formula and instead of TODAY() I used
1/15/2010.
 
L

Luke M

You were pretty close. You have to concatenate the arguement with the value.

=COUNTIF(F11:F369, "<"&TODAY())
 
D

Dave Peterson

try:
=COUNTIF(F11:F369,"<"&TODAY())


I have a cloumn of dates and want to enter a formula that will tell how dates
are older than today. I tried =COUNTIF(F11:F369, "<TODAY()") with no sucess.
The best I could get was using the formula and instead of TODAY() I used
1/15/2010.
Click to expand...
 
J

Jim Thomlinson

Take Today out of the quotes like this to make today back into a function
insted of text...

=COUNTIF(F11:F369, "<" & 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

Use TODAY() function as the criteria in a SUMIF formula 1
Using <= in countifs statement 1
If cell is blank automatically enter today's date in the same cell 21
Total formula 1
Countifs with error #Value! 1
Display weeks from a Milestone 0
dates not recognised 1
Mac Countif function not working at all 0

Top