Forum Discussion
Date of Last Modified for a Cell
When I input this formula only two results come up: 1/0/00 at 12:00 AM or 2/3/23 at 6:34 PM (Today's Date/Time)
This file was created before today and the cells referenced in the cell with Today's Date weren't all modified today.
When I change a cell referenced in the cell with 1/0/00 at 12:00 AM the formula does not update to today's date.
What am I doing wrong?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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?
