Excel/LibreOffice Calc: Short entry of the date | TechBuzz

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.

In Excel, you can type 15-6 or 15/6 to have it interpret that as a date in the current year
(Those: PCtipp.ch)

On the next page you can read how LibreOffice Calc reacts to this and how it can even be adjusted there.