Ask Your Question
0

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

asked 2019-04-28 02:39:22 +0200

IBCurious gravatar image

Example:

01/2019

02/2019

03/2019

04/2019

...

12/2019

01/2020

02/2020

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-04-28 04:45:29 +0200

Cookievore gravatar image

updated 2019-04-29 12:48:09 +0200

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.

image description

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!

edit flag offensive delete link more

Comments

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: https://help.libreoffice.org/Calc/Aut..., but the output I get is (using your data):

03/2019

03/2019

03/2019

03/2019

etc

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.

IBCurious gravatar imageIBCurious ( 2019-04-29 05:05:21 +0200 )edit

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.

IBCurious gravatar imageIBCurious ( 2019-04-29 05:09:26 +0200 )edit

Hello IBCurious, the link to help.libreoffice.org 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, ....?

Cookievore gravatar imageCookievore ( 2019-04-29 12:39:16 +0200 )edit

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

IBCurious gravatar imageIBCurious ( 2019-04-29 12:41:54 +0200 )edit

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.

IBCurious gravatar imageIBCurious ( 2019-04-29 12:49:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-28 02:39:22 +0200

Seen: 73 times

Last updated: Apr 29