Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

RE: Using Dates in Count functions

0 views

Skip to first unread message

Peo Sjoblom

unread,

Dec 6, 2004, 5:25:03 PM12/6/04

Try

=COUNTIF(A1:A10,"<"&DATE(2004,11,1))

Regards,

Peo Sjoblom

"HWade" wrote:

> I want to create a CountIf function using dates but it gives me "0s".... How
> do I use dates in these situations. For example, COUNTIF(A1:A10<11/1/04....
>
> Thanks!

0 new messages