MAKE RESULT OF TODAY() AND NOW() FORMULAS STATIC IN A CELL

[DavidLewies]

I need to convert the date and time values from TODAY() and NOW() formulas into static values into specific cells in a template. This has to be protected, in order to prevent the user of the workbook from changing it.

How do I make such a value static in the cell, as we can't use the method of entry via the keyboard (due to the protected status of the cell)?

Microsoft® Excel® for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20254) 64-bit

[#2 · Accepted solution]

See the answer at https://superuser.com/questions/1287989/how-can-i-make-a-volatile-excel-formula-static-specifically-...

[#3]

Excel works live on data. So you can't stop it from calculating and updating a particular cell.
However, this is achievable via macro. The work around is that you write a macro where you select a cell (your entry date calculated via TODAY() or NOW() function) and press a button, which will replace the formula with the resultant value.

[#4]

Thanks!

[#5]

Thanks!