insert the current date, no update after

Occasional Visitor

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.

2 Replies
best response confirmed by ralf_tegethoff (Occasional Visitor)


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.