SOunds like SUMPRODUCT would work fine for a two criteria lookup using dates....

A sample file with sanitized data would be useful....