I would like to write a formula that adds numbers between certain dates.
Lets say I have this worksheet:

A B
01-01-08 5
01-02-08 7
.......
11-28-08 3
11-29-08 11

In another worksheet, I would like to be able to type in two dates , and
have excel look back at the original worksheet and add all the values in
column B between the two dates listed. Is that possible?

The date ranges will be added anyway, so using them to do the formula would
be much easier than going back and highlighting the data range every time.