Due Date Summary based on multi-sheet spreadsheet
I'm designing the attached spreadsheet to track due dates for a variety of reports. There are actually even more than are on the spreadsheet at the moment.
In most cases, the due date for the document is dependent on some other factor--project approval, release date, etc. I've got it set up so that as the various trigger dates are added, the due dates are updated.
There's a Summary tab on the worksheet. What I would like is to have that tab have a rolling display that always lists the deliverables that are due over the next 10 business days.
I have no idea if it's possible, let alone how to do it.
Any suggestions?
|