Countif date before today

[Joe M.]

I am trying to use countif to count all the dates in column C before today.
To avoid the "volatile" error I have made a cell referencing today:
A1 =today()
A2 =date(year(a1),month(a1),day(a1))
My column C is in another worksheet called "data"
B1 =countif(data!C2:C1000,"<A2") returns zero
In data!C2 the date is 9/19/2006. To test I did this:
=if(data!c2<A2,"true","false") which returns true.
Why is the countif not returning the corerct count?
Thanks!

 

[Bob Phillips]

=countif(data!C2:C1000,"<"&A2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)