Monthly Totals

Hey Everyone,

I'm trying to devise a way to calculate monthly totals automatically. Specifically, I'm thinking about how each year, the amount of days in each month change. Is there a way that I could create a macro to recongnize dates, and what data each month is associated with? The Pseudo Code would resemble:

Check Date Column

Determine what rows are associated with what month

Determine what data is associated with what month

Calculate the sum for that month

When I get this workbook in place, it should be used for years to come. So, I would like it to be automatic with minimal user editing outside of inputing new dates and associated data.

I've attached a simple workbook to clarify my thoughts.

Any thoughts?

Thanks in advance everyone!!