This is difficult and I'm lost! Here is the data (omitting not needed)

A D E
Control # Date Time



2 questions:

1. What formula would I use if I wanted to find out the number of #'s
ocurring on Monday between 1/1/06 and 3/31/06 (1st quarter of the year).
1.a IS there a way not to count diplicates of the control #
only... it would
be ok to count duplicate dates, just not duplicate of
control #'s -
which could occur unfortunately becuase of the way the
data is used.

2. What formula would I use if I wanted to find out the number of #'s
occurring between 0000 hours and 0400 hours between 1/1/06 and 3/31/06?
2.a SAME as 1.a


I tried using the sumproduct formula and am completely screwing that up...
please help!