4

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...

1
  • Could you perhaps list anything you've already tried so we know what didn't work?
    – nhinkle
    Jan 25, 2012 at 7:14

2 Answers 2

7

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.)

EDIT: Step-by-step instructions, as requested, this is now on 4.2.8.2, although I'm sorry I can't help with Windows:

  • Select the range you want to fill. Start with it completely empty.
  • Edit menu, Fill, Series
  • Select "Down" under Direction, "Date" under Series type, and "Weekday" under Time unit.
  • Enter the starting date in Start value (I used YYYY-MM-DD). End value blank, Increment 1.
  • Click OK.
  • Cells are now filled with numbers and selected.
  • Format menu, Cells...
  • Numbers tab, "Date" under category, choose whatever you want under "Format", click OK.
2
  • 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, 2015 at 20:22
  • 1
    On 5.x this menu has been moved to : Sheet -> Fill cells -> Series Sep 2, 2021 at 7:35
0

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]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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