Created attachment 70786 [details] ENTERING a date gives not the expected date (btw 1691 and 1790) When entering a date between 1690-04-06 and 1791-07-27 the indicated value is shifted by one day. This is independent of the calculation mode: 1900-01-01 and 1899-12-30 both show the same behaviour. Since it's at the same date (not number) this might be intentional? I've found nothing in the docs. I cannot see any situation where this is of positive value. At least: it is absolutely undesirable in Germany (and probably most other countries). So if you not simply correct that behaviour there must be a place where a user can change it. [Explanation to the snippet: within s row the values entered are identical, the first column formatted as "Text", the second as "Date", the third as "Number"]
Created attachment 70794 [details] View of the undesired behaviour (if the error does not reproduce on your computer, here you can see it)
I think this one is a DUP of "Bug 52619 - EDITING: 1 day is subtracted if typed date is before July 26, 1790". @reporter: Thank you for your attention! Please feel free to reopen this Bug if you find evidence that we have an independent issue here. *** This bug has been marked as a duplicate of bug 52619 ***