Forum Discussion
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.
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..
Maybe Ctrl+; is plausible? it types the date of today.
In your example I, using shortcuts, would
select C3
type Ctrl+Space to select the data column
type Ctrl+; to type the date
type Ctrl+Enter to enter the same value into the selected cells
In your example I, using shortcuts, would
select C3
type Ctrl+Space to select the data column
type Ctrl+; to type the date
type Ctrl+Enter to enter the same value into the selected cells
- Thing is, this Excel sheet is fully automated. It extracts information from incoming mails and it gets put in the table, hence the reason I need the formula to freeze instead of me constantly coming back to type the Ctrl code.
I fear it may be a lot complicated than I thought- Mm... then the static value of TODAY should be best as a step in the automation. But... that means that a person with possibility to change it does it.
Wether it is a macro or a power query that fetches the emails, it is possible to do.
If it is an excel plug in, it's harder.
It is probably possible to append a macro that automatically exectues after the automated process, and freezes the TODAY value. But include it in the current automation would be my default suggestion.