Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In LibreOffice Calc, I would like to create a column of working days, for example:

[...]
2012-01-30 [Monday]
2012-01-27
2012-01-26
2012-01-25
2012-01-24
2012-01-23 [Monday]
2012-01-20
2012-01-19
2012-01-18
2012-01-17
2012-01-16 [Monday]
[...]

I know there is a way to do this (I've done it before), but now I can't remember...

share|improve this question
    
Could you perhaps list anything you've already tried so we know what didn't work? –  nhinkle Jan 25 '12 at 7:14

2 Answers 2

up vote 2 down vote accepted

This may be new since the question, but (LibreOffice 4.2.7.2 on Linux), Edit->Fill->Series. Choose Date as the series type and Weekday as the Time unit. I found that, after the fill, I had to select the filled cells and Format->Cells to select date formatting. (The original fill was a series of numbers.)

share|improve this answer
    
This doesn't work for me (4.3.2.2 on Windoze), could you please write a walkthroug step by step? I tried on empty cells (I selected 21 cells), I tried to enter 1/05/2015 in first cell (Polish date notation) and setting formatting to 'date'. I also tried filling first and second cell in column with next dates. Nothing worked for me –  Marecky Jun 29 at 20:22

Well, if you already have a similar range of dates then you can get the range you want by using the technique described in the accepted answer to this question.

For example, addding "168:00" (168 hours = 1 week) to

2012-01-23 [Monday]
2012-01-20
2012-01-19
2012-01-18
2012-01-17
2012-01-16 [Monday]

gives you

2012-01-30 [Monday]
2012-01-27
2012-01-26
2012-01-25
2012-01-24
2012-01-23 [Monday]

share|improve this answer

Your Answer

 
discard

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.