Including a time-or datestamp on templates for reports
To insert a time or a date, we can either use the stamp function (e.g. ctrl+;) or use the formula (=TODAY). I would like to have the use of a timestamp inside a template, so that when we create a new sheet from that template, the fixed date appears, i.e. as a datestamp. I haven't found how to do this using help.
Hi Pip! That's amazing, thanks for responding. It works (of course).
You can create time stamps using a recursive formula and setting the calculation iteration to 1.
In Excel->Preferences->Calculation, tick 'Use iterative calculation' and set Maximum Iterations to 1
In a cell, use the following formula:
e.g. in cell A1, you would use
This will set the value of the cell to the current date and time, unless it's already set