I'm not sure if this is possible in Excel.
My current contract has me managing a project for a software implementation. The business doesn't have Microsoft Project so I've drawn up a project task list for the next three months.
The tasks and responsible party(s) I've listed in the far left two columns with each column thereafter headed by the day and date in sequence through to end of May. What I would like is to have some form of indicator which comes from the top row (which contains each day and date) through to the last row indicating the current date. This would update automatically based on the current date and therefore give some perspective on what stage the parties should have reached with their task.
Updating the date automatically is easy but having a moving indicator across the spreadsheet is where I get stuck.
Looking forward to hearing from anybody who could help me.
Bookmarks