|My mistake, let's use this as an example:|
Cell C5 is the input cell for the user, they input 1/1/2012
Cell C10 is the calculated cell, showing the date 2/18/12, 48 days later, which is when the document is due for review.
I want to put in a drop-down menu in cell D10 as a "status" of the report.
D10 will have both "Working" and "Completed" options in the drop-down menu.
If the review was finished ahead of schedule, say 2/4/2012, and the D10 drop-down menu is changed over to "Completed" I want the C10 cell to update to whatever date D10 was changed.
The updated date will trigger the formulas for the rest of the spreadsheet.
I cannot get C10 to read the D10 drop-down menu.
I know the "TODAY()" function won't work, and am not sure if there is a function that just pulls up the current date the field was changed.
Sorry for the confusion, hope this clears it up.