I am looking for a way for a date field in Excel to automatically apply today’s date when I enter data. That is straightforward enough but then I want that date to remain as is forever more. Unfortunately it seems to want to keep applying the current date.
Is there a way to do this in an automated fashion? I know I could manually tell it to just be data and not autofill anymore but then I may as well just manually type in the date.
You can definitely do it in VBA.
You could write a macro that has it copy that row and do paste:special:values.
StG
FWIW, typing “ctrl-:” (control colon) will put today’s date in a cell as static data. It’s a lot easier than typing it all in every time, though not automatic.
I came back to this today hoping that somebody would reveal a way of doing this without VBA code but apparently there isn’t a function that monitors another cell for change.
You didn’t say whether or not you wanted a function or whether you wanted (or understood) VBA routines (macros).
In VBA there is a Worksheet_Change event which is useful for triggering an input into one cell when another one changes. Examples of the code including an auto time/date input method can be found at this link.
I haven’t tried these and I’ve read that the event has some caveats like not working for reformats and comment changes.
If you are familiar with VBA you may be able to toy around with one of these routines and fit them in to your application.
Good Luck
Actually, I just tried it & its ctrl-; (control semi-colon). Ctrl-: (control colon) puts the time in the cell.
Cool trick, though! Thanks.