Screen Shot 2013-02-28 at 5.55.44 PM.png
Above I have a list of projects, each on a new row, each with a start and end date. I need to take this information and organize it into a month by month forecast, the outline of which should look something like this:
Screen Shot 2013-02-28 at 6.00.11 PM.png
Is this possible or reasonable to do? 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?
Thanks,
James
(Excel 2013 / Windows 8)
Bookmarks