Forum Discussion
Date of Last Modified for a Cell
Thanks for this formula. When I am trying it on the my excel sheet, it displays date as 01/00/1900, 12:00AM, and not the current date and time. Do you know what error I might be making? Thanks
Did you follow all the instructions from my first reply? You have to enable iterative calculation before entering the formulas.
HansVogelaar --thanks for helping all of us!
I read all of the previous replies. I cannot see the Drive file so I am hoping you can help me with my error.
I want column B to autofill with the date when its corresponding cell in column A is edited. Am I going about this incorrectly?
I know I have it populating in C, this was for demo. 🙂
If you want to enter the date in column B when the corresponding cell in column A is filled for the first time, you can use a formula. (Or did you mean column C instead of column A?)
If you want to enter the date in column B whenever the corresponding cell in column A is edited, you'll need VBA code.
Which do you want?
I want the date in B to autofill/update whenever changes are made to the corresponding cell in column A. I thought I wanted the same thing the original post stated. Minus the time (not necessary) and the fact that they wanted their info on the same column? What could I change to be able to use the formula you originally gave?