SOLVED

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

New Contributor

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

4 Replies
best response confirmed by DavidLewies (New Contributor)
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.