Having issues with date display in my spreadsheet
I’m using the TODAY function in Google Sheets but it keeps showing the wrong date. Right now it’s March 31st 2023 but my cell displays April 1st 2023 instead. My phone and computer both show the correct date so I’m not sure what’s going on.
I checked my device timezone settings and they look fine. Also tried the official Google help docs but still getting the same wrong date showing up. Has anyone else run into this problem before? What could be causing the TODAY formula to be off by exactly one day?
check the spreedsheet’s timezone settings, not just ur device. go to file > settings and see what timezone it’s using. i had the same issue and switching it fixed my dates.
Had the same headache a few months ago. The issue can stick around even after you fix timezone settings because Sheets caches the old data. Create a new spreadsheet and test TODAY() there first - if it works in the new sheet, your original one’s stuck with cached settings. Force a refresh by closing the spreadsheet completely, wait a few minutes, then reopen it. Another trick I found: temporarily switch your Google account timezone to something totally different, wait 10 minutes, then switch back. This clears whatever cached data was messing up your dates.
This happens because your Google account was created in a different timezone than where you are now. The spreadsheet pulls its timezone from your account settings, not your device. Go to myaccount.google.com, click Data & Privacy, and find the timezone setting. Change it there, refresh your spreadsheet, and TODAY should show the right date. I had this exact problem when I moved countries - took me forever to realize the account timezone was messing things up.