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

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

--
Regards

Roger Govier


"Sachin Narute" wrote in message
...
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

On Mon, 1 Aug 2005 06:06:09 -0700, "Sachin Narute"
wrote:

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