Proton Sheets - Additional Date Formats
Currently it appears the only possible Date format for Date types in Proton Sheets is mm/dd/yyyy, which is US centric.
Would appreciate additionally including other date arrangements, perhaps:
dd/mm/yyyy (Common globally)
dd/mm/yy
yyyy/mm/dd (ISO 8601)
dd/mmm/yyyy
Would suggest dd/mm/yyyy given that it's arguably the most common format globally and yyyy-mm-dd given that it's the ISO 8601 international standard used heavily in software around the world should be priorities 👍
-
Cédric Mallet
commented
it is quite embarrassing for a Swiss company to select the US date format and make it non-modifiable. None of us wants to read a date with the month first. At first I though the sheet would use my browser or system region but even with everything in French or UK English I still have the dates in MM/DD/YYYY. It's a no go to use Proton Sheets for me.
-
Hanna commented
I always use YYYY-MM-DD, it's the easiest way for me and easiest to sort. I have it in all my documents
-
imaginewagons
commented
This feature is super important for me. I'm migrating from google as a Proton paying customer.
-
Mistral
commented
yeah. at least ISO-standard date formats should be supported.
-
Matthias
commented
I am flabbergasted Proton Sheets launched without such a basic and essential feature... and then even defaults to the US date format even though being an european service. Since Proton Docs was released, I was hoping for a Proton Sheets so I could finally leave Google Docs behind. When that finally happened, I was over the moon... but in its current state, it is simply not able to compete with or be a replacement for Google Docs Sheets. :-(
Hopefully the date and time format gets as customizable as it is with Google Docs. That would be a great step forward.
-
Leo Moons
commented
DD/MM/YYYY is my favorite, and it is not easy to convert with formulae.
-
Johan E. Bengtsson commented
dd-mm-yyy is not the international date format - YYYY-MM-DD is.
This issue appears to be a duplicate of an issue higher up - can someone merge it?
-
Jon Saville
commented
Agreed that we should be able to specify this manually, but Sheets should pick up the default from the browser environment like any other application.
-
Richard Stanley
commented
Backing this, I need dd-mm-yyyy or I'm unable to use Sheets. I've been waiting for this program very keenly - the last piece of the puzzle so I can ditch Google for good - but I can't use it yet.
-
Marcelo
commented
Same as Lance, I need to have dd-MM-YYYY Format
-
Lance
commented
It is not only the yyyy-mm-dd format, but it is also VERY importantly the international format of dd-mm-yyyyy etc are available.
I am not an American, and I use international formats. If you don't fully support that, then Proton Sheets is not an option.
-
ais
commented
There should be an option to provide a date format.
I need YYYY-MM-DD, which is easy to enter myself if given the option.
-
Tringhamm
commented
When importing an existent spreadsheet that I created with Google Drive, I was able to use cells with DD/MM/YYYY. It was recognized as a date field. But indeed it is necessary to have more formats.
-
Anonymous
commented
đź’Ż I imagine date formatting will quickly become an issue for this global audience.
-
Pavel
commented
And dd.mm.yyyy (used for example in the Czech Republic) would be great.
-
Chris Barnes
commented
In Proton Sheets, Format -> Number, please add an option for an ISO 8601 date format (YYYY-MM-DD).