I'm using Chrome on Mac. The keyboard shortcut for inserting the date into a cell is CMD+; but for some reason it always inserts tomorrow's date, not today's. My computer's clock is definitely set correctly, and it's many hours before midnight so it wouldn't likely be a timezone oddity either.
So why is this happening? Bug? Misunderstanding of the feature?
Best Answer
The solution as posted in a previous comment (since removed apparently) was to check the
Spreadsheet Settings
in thefile
menu and ensure it was set to the correct timezone. It was not, so that's why the date was off.