How to input creation date into Excel report
-
I have an Excel report and I want to be able to include the data of the report in one of the cells. If I use the =TODAY() formula it will change each time the report is opened and printed.
How can I set the cell to the data it was created?
-
We are planning to add in some features so you can add in things like the time that the report was run. You could also just create the cell with the named range of "time.lastTime" If you bind a data point that is logging regularly it will insert the last time stamp of that data point. You could also create a virtual data point or meta datapoint to store a time value.