Here's what I've been trying to do...

Sheet 1 has dates in column A for all the working days in a month. The other columns B onwards until AL have data, and I need to use this data depending upon the required criteria to populate sheet 2.

Sheet 2 has the working weekdays (start date and end date) in Column A2 & B2. In other words, if a Monday is on June 4(Column A) and Friday is June 8(Column B) , then I should be able sum (using Sumifs function) the data in sheet 2 for all items that are in sheet 1 in columns C3, D3 etc... within that date range (June 4-8), and similarly for the next week (June 11 cell A3 and June 15 cell B3, and so on for the remaining 2 weeks....

Hope this makes sense of what I'm trying to get at...

Please advise your thoughts...