countif
 

I have a column with 3 years worth of random dates (2006, 2007, and 2008)
with the data is set up as Date. I want to count the number of date before
1/1/2007. I am using countif(C4:C299,"=1/1/2007"), the return value is 0.
When i do countif(C4:C299, "9/13/2006"), it does result in a correct value.
Only when i use < or sign then the software won't count. Any suggestion?
Thanks for your input.

countif
 

Try

=COUNTIF(A:A,"<=" & DATE(2007,1,1))

If this post helps click Yes
---------------
Jacob Skaria


"kakymoau" wrote:

I have a column with 3 years worth of random dates (2006, 2007, and 2008)
with the data is set up as Date. I want to count the number of date before
1/1/2007. I am using countif(C4:C299,"=1/1/2007"), the return value is 0.
When i do countif(C4:C299, "9/13/2006"), it does result in a correct value.
Only when i use < or sign then the software won't count. Any suggestion?
Thanks for your input.

countif
 

Presumably you have a cell in your worksheet that holds the date condition
(this can be entered into cell A1 using =DATE(2006,1,1) or whatever date you
need to test). If your random dates i.e. 2006, 2007 etc are indeed numbers
then the following formula should do the trick.

=COUNT(IF(yourdaterange<YEAR(A1),yourdaterange,"") )

This should be entered as an array formula.

Hope this helps

Regards

Paul


"kakymoau" wrote in message
...
I have a column with 3 years worth of random dates (2006, 2007, and 2008)
with the data is set up as Date. I want to count the number of date before
1/1/2007. I am using countif(C4:C299,"=1/1/2007"), the return value is 0.
When i do countif(C4:C299, "9/13/2006"), it does result in a correct
value.
Only when i use < or sign then the software won't count. Any suggestion?
Thanks for your input.