Count Function

[Guest]

i have one cell as

A B
TC Detected Date
1 06-Jul-05
2 06-Jul-05
3 08-Jul-05
4 10-Jul-05
5 10-Jul-05
6 12-Jul-05
7 12-Jul-05
8 13-Jul-05
9 13-Jul-05
10 14-Jul-05
Now i want formula to count no of TC detected From date 08-Jul-05 to
13-Jul-05 (1 week)
Here ans is 9.
Plz Help me i am new to excel.

Regards,

Sachin

 

[Roger Govier]

=SUMPRODUCT(--($B$2:$B$10>=DATE(2005,7,8),--($B$2:$B$100<=DATE(2005,7,13))

 

[Ron Rosenfeld]

i have one cell as

A B
TC Detected Date
1 06-Jul-05
2 06-Jul-05
3 08-Jul-05
4 10-Jul-05
5 10-Jul-05
6 12-Jul-05
7 12-Jul-05
8 13-Jul-05
9 13-Jul-05
10 14-Jul-05
Now i want formula to count no of TC detected From date 08-Jul-05 to
13-Jul-05 (1 week)
Here ans is 9.
Plz Help me i am new to excel.

Regards,

Sachin

Aside from the fact that I get a 7, the general formula would be:

=COUNTIF(rng,">="&A1)-COUNTIF(rng,">"&A2)

where rng is the reference to your list of dates; A1 contains the first date
you wish to include; and A2 contains the last date you wish to include.


--ron