Creating formula to add data in fields based on date

[VickieN]

I have a spreadsheet that forecasts cash and is updated weekly by other users for the upcoming 12 weeks and then sent to me. Each column heading is a day of the week and the dates change as new weekly reports are submitted. I need a calculation in the report template that will automatically add the data in the fields based on dates. As an example, if the date of the report was 11/14/05 - 2/3/06, I would need to add all the data in the fields associated with the November dates, and then add the data in the fields associated with the December dates, and so on. Can anyone help with a formula or macro to do this?

 

[VickieN]

Thank you very much. I will give it a try!