My apologies; I can't yet post pictures so these are links to screencaps of my two worksheets:
As you may have guessed, I need to compile the data from the projects into a month by month summary, based on their respective start and end dates. I've looked into vlookup(), match() and offset()—it seems these functions may hold the key but it's a very complex task and I'm not really sure where to start. Is there a function (or set of functions) that's better suited for this kind of work? How would you tackle it?