I have a spreadsheet that lists 400 items.
Each item has a set of eight dates which reflect the project lifecycle of the item from requirements signed off, specification signed off through to test sign off and Live date.
I have a function called Status that takes as input these eight dates and another pivot date and returns the current status of the item as per the pivot date.
Now my question is as follows. Each function in the status column is
Each time one of the dates is changed then Excel recalculates the entire spreadsheet rather than just the one line.
Is there any way of getting round this?
Calling Date in each function is inefficient so
What I have tried is to store the date in a cell in the spreadsheet and then had the status function thus:
and then in the Status function retrieved the Date value from the cell. However this approach was also slow and had other problems associated with it.
Is there any way of storing variables with the spreadsheet?