Increase date in month / year (mm/yyyy date formated column) by one month (mm) using AutoFill or Any simpler method









Know this should be simple but have not been able to find the answer. Most likely don’t know the right question to ask. Please be very specific as I am very rusty on spreadsheets. Thank you.

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

image description (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!

Thank you so very much for your prompt and detailed answer, The problem I am having is that (if I’m correct) I am using your answer which I believe is here: Automatically Calculating Series - LibreOffice Help, but the output I get is (using your data):






I apologize for no screenshots, it’s a little complicated when I looked it up.

I will gladly accept more help if you are willing.

Thank you again.

I also forgot to mention that I tried it with days of the week, Monday, Tuesday … Sunday and it worked as advertised.

And, I guess I could have used “edit”. First time doing this.

Hello IBCurious, the link to is exact what you are looking for. The problem here maybe is that MM/YYYY is not automatically recognised as date. You’ll see due to your input is left-justified or right-justified in the cell. Left = text, right = date. Text = not the wanted autofill function, date = should workout as what you are looking for.

So you say, you have first formated two cells (one is not enough to catch the pattern) as date and with your desired style with Format-Code MM/YYYY and then you fill 03/2019 and 04/2019 into it and these two cells show up with 03/2019, 04/2019? After that you marked these two cells, picked the handle in the bottom right corner and draged it down? And the result is 03/2019, 03/2019, 03/2019, …?

Please hold on for a little while. I’m trying something different and will report back when I have further info. Thank you

Boy you’re Quick, That appears to be the case. So as I said over you, Looking at this a little differently in an Empty Spread sheet and will report back when I have time. Thank you so much.