Forum Discussion
Excel for simple project management - date dependency problems
Hello friends - I have set up a spreadsheet with dozens of tasks related to producing a children's theatre production. Each task's target due date is dependent on either the date we begin rehearsing,...
There are at least several ways to address this, and much depends on things you haven't told us.
- How, for example, are the various shows laid our in your spreadsheet?
- Do you have a different spreadsheet for each show, or are they all on the same single worksheet?
- Are all of the dates for any given show on the same row?
- Or do you have as many as 300 rows for each show, where those different calculations are done, and D1 and D2 are at the top of each sheet for each row?
For now, then, if it's something like that last question, then in your formulas use $D$2 and the like. That is what's called an Absolute Reference, as opposed to a Relative Reference The latter is what you've been doing, and what gets messed up when you sort. You can learn more about those two ways of referring to other cells by clicking on the hyperlinks I provided.
There are more questions that could be asked. So if that absolute/relative reference suggestion doesn't solve it, please come back with more details about how your workbook/spreadsheet(s) are organized.