Hello,

Here is my spreadsheet:
Col A Col B Col C
08/01/06 10/01/06 2,500
11/01/06 10/01/16 8,000

Column A = Start Date
Column B = End Date
Column C = Dollar Amount

I have a range of dates in Column F - they are all dates that start with the
first of the month. So basically, if one of those dates in Column F fall
within a date range (between column A and B) it needs to return the value
from column C.

Example, if a date in Column F is 09/01/06 - it should return the value of
2,500.
Example 2 - if the date is 02/01/10 - the value it should return is 8,000.

I completely appreciate any help that you can provide.
THANKS!
Rob