Hi,
I have a spreadsheet with the following in one of the cells:
=TODAY()-1
This used to always print *yesterday's* date. Recently, when I open the file, it prints a date *before* yesterday - perhaps it prints the date which represents the last date the file was opened, I'm not sure.
It is weird because if I go into and edit the cell, by simply pressing Enter, the correct value (i.e. yesterday's date) is displayed!
Any ideas why this cell (and other similar ones) in my spreadsheet don't display the correct values unless I go into each of the cells and press Enter?
As I say, it used to work, but doesn't anymore.
Cheers!
Bookmarks