I need to have the last date entered in excel automatically show up in another cell. Let me explain... I have an "Original Expected Ship Date" in cell A1 and then I have revised dates in cells B1, C1, and D1. I need those dates as a history to this order. I want my date in A1 to automatically change and show the last modified date in any of these three cells (B1, C1, D1). How do I do this?