View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default =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.