Making Excel formulas only evaluate once
Fresh3 days ago
Mar 15, 202641421 viewsConfidence Score0%
0%
Problem
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.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Making Excel formulas only evaluate once
Low Risk
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…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix