J
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!
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!