Local time using now() function

I’m using the now() function to set the default date in a date input to be today.

However, I’ve noticed that it is operating in a different timezone to me. It’s operating in USA time (I think PST), and not London time where I am.

Thus when I add an entry in morning it is using yesterday’s date.

Is there a way to have it set to Today’s date in the REAL user timezone?

Here’s a couple of threads that you might find useful:


What spreadsheet timezone are you using?