Timeline for When typing a date into cell as 12/24, parse it as Dec 1 2024, instead of Dec 24, 2020. (dd/dd to Month Year rather then Month Day)
Current License: CC BY-SA 4.0
6 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Oct 31, 2020 at 23:26 | comment | added | CeePlusPlus | Well I guess an answer I don't want to hear is still a correct answer. Thank you. | |
Oct 31, 2020 at 23:26 | vote | accept | CeePlusPlus | ||
Oct 30, 2020 at 9:13 | comment | added | Tedinoz | “because one could also write 01-07-22 and Google will still understand a date. ” Indeed, an important distinction. Thank you. | |
Oct 29, 2020 at 17:35 | comment | added | marikamitsos |
@Tedinoz To be clearer "a date as day/month/year or month/day/year pending on your locale". I am saying that because one could also write 01-07-22 and Google will still understand a date.
|
|
Oct 29, 2020 at 7:15 | comment | added | Tedinoz |
Just to be clear, a user should enter 01/07/22 and format the cell as Month/Year.
|
|
Oct 29, 2020 at 2:39 | history | answered | marikamitsos | CC BY-SA 4.0 |