<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Dates are not correctly auto-extrapolated if exclude days" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144377#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Dates are not correctly auto-extrapolated if exclude days" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144377">bug 144377</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>But if you want to *enter* dates using such a notation, you need to tweak *date acceptance patterns* at Options->Language Settings->Languages [1]. There you may specify a Y-M pattern, and then when you enter 2019-01, Calc will convert it to 2019-01-01 (implicitly adding the minimal value of the missing element). Then the resulting *proper date* in the cell may be displayed according to the format that you choose. [1] <a href="https://help.libreoffice.org/7.2/en-US/text/shared/optionen/01140000.html?DbPAR=CALC#bm_id9471429">https://help.libreoffice.org/7.2/en-US/text/shared/optionen/01140000.html?DbPAR=CALC#bm_id9471429</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>