Forum Discussion
Solved
insert the current date, no update after
Hallo I'm new, I hope it is possible to do.... How can I insert the current date into a formula. It must NOT update after insertion.
That's not straightforward. Please check here Create A Timestamp In Excel With Formulas - How To Excel At Excel how to add timestamp by formulas.
Another reference:
5 Ways to Get the Current Date or Time in Excel | How To Excel
This shows how a timestamp may be entered manually.
To create a timestamp as a by-product of some other action requires workarounds to achieve something that functional programming is intended to prevent. Imperative programming, as supported by VBA, is intended to allow variables to change over time as instructions are encountered. Worksheet change events can trigger the instruction but that is getting fairly advanced.