I'm thinking this must be impossible becasue I haven't received any response. If there is anybody pretty knowlegeable and they know it is impossible or think it is would you please tell me and I will stop driving myself crazy trying to figure it out

1st Column 2nd column 3rd Column
3/31/04 $500.00 2/1/02
2/01/01 600.00 1/15/04

I want to pick up any dollar amount that falls within the 1qt 04, whether it is the first or third column. So I should pick up $1,100.00. I had a code that picked up the first column but of course somebody always has to change something, and now they tell me if the 3rd column has a 1qt 04 date they want it also.
This is the code I am trying to use.
If anybody would know of another site that would explain this or a book that I could read about this or ANYTHING, I would be forever greatful!!! Please

Application.Worksheets("Dates").Columns("g").Numbe rFormat = "mm/dd/yy"
Application.Worksheets("Dates").Columns("l").Numbe rFormat = "mm/dd/yy"

For Each Cell In Range("NoteList")
Cell.Offset(0, 5).Value = Cell.Offset(0, 5).Value 'this being the first date
Cell.Offset(0, 10).Value = Cell.Offset(0, 10).Value 'this being the second date
If Cell.Offset(0, 5) Range("HistDate") And Cell.Offset(0, 5) <= Range("controldate") Then
If Cell.Offset(0, 10) Range("HistDate") And Cell.Offset(0, 10) <= Range("controldate") Then

Select Case Cell.Offset(0, 2) 'this being the amount