Jul 08 2021 11:46 PM
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.
Jul 09 2021 12:03 AM
SolutionThat's not straightforward. Please check here Create A Timestamp In Excel With Formulas - How To Excel At Excel how to add timestamp by formulas.
Jul 09 2021 12:29 AM
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.
Jul 09 2021 12:03 AM
SolutionThat's not straightforward. Please check here Create A Timestamp In Excel With Formulas - How To Excel At Excel how to add timestamp by formulas.