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.