Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to input in a libreoffice calc file only Mondays and Wednesdays for the next 5 months, but I dont wanna do it typing the dates one by one. So..I thought I would type 4 dates like this:

17. Mar. 2014   Monday  
19. Mar. 2014   Wednesday  
24. Mar. 2014   Monday  
26. Mar. 2014   Wednesday  

Then I thought highlighting these dates and dragging them would give me all the Mondays and Wednesdays up to the a point where I drag it....but this is what I get:

17. Mar. 2014   Monday
19. Mar. 2014   Wednesday
24. Mar. 2014   Monday
26. Mar. 2014   Wednesday
18. Mar. 2014   Thursday
20. Mar. 2014   Friday
25. Mar. 2014   Saturday
27. Mar. 2014   Sunday

Is there a way for me to put only Mondays and Wednesdays in a fairly simple way instead of typing them one by one?

share|improve this question
You're right, the question isn't understandable. You want to copy Monday's and Wednesdays'.... what? Also, please take the time to format the question correctly -1 – Dave Feb 6 '14 at 14:06
Please give more details! – Alejandro Sazo Feb 6 '14 at 14:24
There. Just edited it. I hopè it helps. I simply wanna find an easy, automated way to write Mondays and Wednesdays into an libreoffice calc file instead of typing them in one by one. – Elysium Feb 6 '14 at 17:25

Write the first 2 days that you want, say 17 Mar 2014 and 19 Mar 2014 and the associated day-of-week in the cells beside them.

Cell A3 is =A1+7

Cell A4 is =A2+7

Drag and repeat.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.