I use an Excel planning sheet as a resource planner.
I have dates listed and people. Against the people tasks are allocated.
What I want to be able to do is from 'todays date' calculate when a project would end based upon how many blank cells are available and how many cells (days) I know would be needed to complete the project.
An example of my sheet is attached with a scenario included. Hope someone can help please.
Bookmarks