I don't think that equation is going to do what you want. I copied the equation to a spreadsheet and changed the range. I checked it in the formula builder and it says the criteria is volatile. Whenever I added any number to the range, it simply incremented the result with the value.

What are you trying to do? Are you just trying to add those data under the dates that meet the criteria? Are the digits in Row 2 dates formatted to just show the date? That would make it easier. Simpler still, forget putting the month in Row 1 and just put the complete date in Row 2.

Also, check your criteria. You are asking to sum all dates earlier than 60 days ago and one date 60 days from now.

How this can be done is eluding me now. It's late and I need to hit the rack.