I have searched through many threads and many websites and can't find the pieces to accomplish this task.
I have a date in column G of my worksheet and I want to subtract the current date from it and put the difference (either positive or negative) in column H.
I want this to be done when the workbook is opened but once the calculation has populated column H it should never update it. In other words, if I open the workbook and column H is populated and I subsequently save and close the workbook, the next time I open it the calculation will leave the already existing values in column H alone.
This is a document metric workbook stored in a restricted location so no one else can save it back to that location. It is dynamically updated with current dates that documents are, or will be, due for review. Column H will be negative if the doc is already overdue, or positive if it is not yet due. Since we grab a "current" update once a week, we want to be able to store it in another location and not have the metric in column H change when we open the workbook at a later date.
Bookmarks