Counting cell on condition

[navin]

Hi,

I have sheet, in which Col A contains dates, now i have to calculate
the dates with the condition of >= and <=.

for example:

Col A

01/01/07
01/01/07
01/01/07
01/01/07
01/01/07
01/02/07
01/02/07
01/02/07
01/02/07
01/02/07
01/03/07
01/03/07
01/03/07
01/03/07
01/04/07
01/04/07
01/04/07
01/04/07
01/04/07

Now in cell B2,i have to count the dates which are between 01/01/07
and 01/02/07. Please help.

thanks,
navin

 

[@Homeonthecouch]

If you have the first 01/01/07 in A1 then try
=COUNTIF(A:A,A1)

Hope this helps

Andrew

 

[Don Guillett]

=sumproduct((a2:a22>=b1)*(a2:a22<b2))

 

[Bob Umlas]

=SUMPRODUCT(--(a2:a22>=b1),--(a2:a22<b2))
Bob Umlas