I would appreciate anyone that could help me with the following problem. I
hope this is short enough yet gives you the information to solve the
problem.
The weekly reconciliation formula in column D should return a result that
takes the date in (for examle) C1, compares it to the dates in column A for
Income and sums the amounts in column B if the date is between the previous
reconciliation and the date in C1. The formula than should do the same for
Bills in with the difference of the two being the result returned in column D.

Income Weekly Reconciliation
(A) (B) (C) (D)
(1) 2/18/07 420.00 2/23/07 (Formula)
(2) 2/25/07 324.00 3/2/07 (Formula)
(3) 2/28/07 237.00
Bills
(4) 2/14/07 278.00
(5) 2/16/07 158.00
(6) 2/19/07 279.00
(7) 3/1/07 100.00