1

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?

4

The solution as posted in a previous comment (since removed apparently) was to check the Spreadsheet Settings in the file menu and ensure it was set to the correct timezone. It was not, so that's why the date was off.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.