Forum Discussion
Date of Last Modified for a Cell
Here's a Google Drive link: https://drive.google.com/file/d/1RP6xgA8oyYEU1vnrzclOKKahs8MfGyJ5/view?usp=sharing
The formula will work if column C is initially empty.
If you then enter something in a cell in column C, the current date and time will be entered in the corresponding cell in column E, and it won't change anymore.
HansVogelaar I apologize for treading up an old thread.
but is there a way to make the formula work to update the date and time every time the data cell changes and not just the first time the cell receives data input? Regardless if the data cell had data to begin with?That requires VBA code (for Windows and Mac, it won't work in Excel Online, nor on Android or iPhone/iPad).
See the attachment to my reply 5 replies above this one.
- When using VBA, can you pls suggest how to protect the cells with dates to prevent user modifications?
I tried the lock cell + protect sheet, but VBA goes on error because it cannot update them too.
HansVogelaar
Amazing formula, I've got a use case for it too in one of my query table but whenever the query refreshes, the date jumps back to 1/0/00 at 12:00AM
Any idea why?I guess this won't work with a query table. You'd probably need VBA code instead of a formula.
