In the near future…
Did you know that you can also enter a date shorter than «15.6.22» in Excel? And in LibreOffice you can even customize it.
Excel mini tip in advance
If today’s date is to be entered in a cell, simply press once after clicking on the cell Ctrl+Point (ctrl+Point). Make sure you use the punctuation dot (second right of the M) though. It doesn’t work with the decimal point of the numeric keypad. By the way, LibreOffice Calc does not know this abbreviation.
Also use when entering data Not the formula =TODAY(), because it enters the current date with every recalculation. If you entered «=TODAY()» in a cell on June 12, 2022, June 15, 2022 will appear there as June 15, 2022.
But how is it shorter now?
In Microsoft Excel you can use two different short forms of the date without the year, which also work via the numeric keypad: Both 15-6 as well as 15/6 is interpreted by Excel as June 15 of the current year.
On the next page you can read how LibreOffice Calc reacts to this and how it can even be adjusted there.