I'd like to enter yesterday's date in certain cells in googlesheet, and not have it autoupdate. e.g., TODAY() and NOW() autoupdate. I know I can use Ctrl+; to get today's date, and that remains static. I need the equivalent for yesterday's date.
Googling hasn't turned up anything yet, and neither has the googlesheet docs.
Use
TODAY()-1 or NOW()-1Then copy > paste as values only
The above works because Google Sheets dates are serial numbers where the unit is 1 day.
You could create a macro that does the above which could be called by using a keyboard shortcut. For details about how to create a macro please read https://developers.google.com/apps-script/guides/sheets/macros