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