Hi,

I need to figure out a formula that well count the number of scanners sent
out per week. Sounds simple, right? The days are listed using the DATE
function. The scanner information is in the column next to the weekdays.


ie


Date Scanner Serial #
1/1/2003 4963102150900054
2/10/2003 4963102150900934




2/18/2003 ?
4963102150900284


2/25/2003 4963102150901707
2/25/2003 4963102150901033
2/24/2003 4963102150901801
2/25/2003 4963102150901308
2/26/2003
3/3/2003
3/4/2003
3/17/2003 4963102150901396
3/18/2003 4963102150900391
3/20/2003 4963102150901034



I really could use some suggestions. (should I use the WEEKDAY function
with the COUNT function?)


TIA