I am trying to write a count if formula to count the total in A1:A3 and count
it to what is in B4:7 in D on if the date in B1:B3 falls in the range of the
date given in D2 and on. Examples below

Thank you for the help



A B C
1 NBC 4/20/09 7865.42

2 NBC 3/28/09 1268.42

3 NBC 4/22/09 1000.00



A D E F
1 Week Start Week Start Week Start

2 3/30/09 4/13/09 4/27/09
4 NBC 1268.42 8865.42