=COUNTIF formula
 

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.

=COUNTIF formula
 

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

=COUNTIF(F11:F369, "<"&TODAY())
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bob" wrote:

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.

=COUNTIF formula
 

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



Bob wrote:

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.

--

Dave Peterson

=COUNTIF formula
 

=COUNTIF($F$1:$F$33, "<"& TODAY())

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob" wrote in message
...
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.

=COUNTIF formula
 

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

=COUNTIF(F11:F369, "<" & TODAY())
--
HTH...

Jim Thomlinson


"Bob" wrote:

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.