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
add comment

1 Answer

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
add comment

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.