Forum Discussion

PAtesting's avatar
PAtesting
Copper Contributor
Mar 07, 2022

Freeze =TODAY

Is it possible to freeze the result of =TODAY, so it doesn't update the date everytime I open the sheet?   I need the =TODAY function to stay fixed.
Formulas and Functions
PAtesting's avatar
PAtesting
Copper Contributor
Mar 07, 2022

paolive 

 

How do I apply it to my example? I tried to break the formula (presented in your example) down but I just don't get it.

 

 

Column C has the =TODAY formula I am trying to freeze, because it is essential that the days-prior-or-after-the-deadline information in column D does not change.. 

paolive's avatar
paolive
Icon for Microsoft rankMicrosoft
Mar 07, 2022

PAtesting I was thinking and maybe what you need is something simpler. You know that if you press F9 inside a formula, for example double click in cell C2 and press F9, it will convert to the value? This way you just need to press F9 inside that cell to "freeze" the function.