Mar 07 2022 03:03 AM
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.
Mar 07 2022 03:10 AM
Mar 07 2022 05:04 AM
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..
Mar 07 2022 07:29 AM
@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.
Mar 07 2022 11:01 AM
Mar 08 2022 05:44 AM
Mar 08 2022 06:10 AM