Hello, other than Excel, Calc does not recognise the pattern if it is not previously formated as date. So you could format say two first cells as date in the desired format, enter two first valid dates, which will be reformated as just defined and than you can use the autofill function. (Mark the two cells with the pattern, left-click on the small dot on the right lower corner, drag this down.) See attached screenshots.
![image description](https://ask.libreoffice.org/uploads/asklibo/original/2X/e/ee4dd8d114c21ae07d6f1518c3714ff90eff29e4.jpeg)
(Update)
The desired format of the cell can be done by formating the date style.
Of course it’s MM/YYYY for your language.
To show the community your question has been answered, click the check mark (✓) next to the correct answer. Also you could ‘upvote’ by clicking on the up arrow (^) for any helpful answers. This is the mechanisms for communicating the quality of the Q&A on this site. Thanks!