Is there any way to embed the result of a formula evaluation in a cell, such that the evaluation only happens once?
For example: If I put =TODAY() formula in a cell today, if I open the spreadsheet tomorrow I want yesterday's date to be displayed in that cell.
Best Answer
In some cases where you want to get a static answer from a formula you can do what you want without using a formula.
In your example Excel doesn't know whether TODAY() was meant to mean today's date or the date that it was entered in the spreadsheet.
You can, however insert the current date and/or time in a cell: You can select a cell and press
CTRL+;
orCTRL+SHIFT+;
for current date and current time respectively (for bothCTRL+; then SPACE then CTRL+SHIFT+;
).In other cases, I tend to
copy
and thenpaste special
asvalue
.