LibreOffice Calc/Writer: How to get the dates for specifc weekdays per month?

Posted by Phin on Super User See other posts from Super User or by Phin
Published on 2012-12-19T00:27:42Z Indexed on 2012/12/19 5:05 UTC
Read the original article Hit count: 467

Filed under:

libreoffice

|

date

|

writer

I'm stuck with a problem in LibreOffice Calc or Writer:

I try to get a table of dates for every monday, wednesday and friday per month, something that I can load every new month wich sets the dates automatically so I just have to print the page on paper. :)

In Writer the fieldcommand for date can't obviosly do the job (it only can be set to a fix date, the todays date or +offset as far as I can see).

In Calc I tried it with the autofill but that obviosly works for the first 3 days only.

I might add that I'm lost with Excel/calc formulars...

Any help?

© Super User or respective owner

Related posts about libreoffice

Going back (downgrade) from LibreOffice 4 to LibreOffice 3

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
EDIT This question is not at all a duplicate of How to downgrade from LibreOffice 4.0 to 3.6? The above mentioned question talks about downgrading from a specific version of LibreOffice, namely from 4.0 to 3.6. The solutions mentioned are not the ones I am looking for. They will work but I wanted… >>> More
libreoffice-base not configured yet

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have the LibreOffice ppa installed (ppa:libreoffice/ppa) and today I had a problem after updating. I got the following error. Reading package lists ... Done Building dependency tree Reading state information ... Ready You might want to run 'apt-get -f install' to correct these. The following packages… >>> More
LibreOffice - Can't drag and replace images [LibreOffice 3.5 and 3.6, Ubuntu 12.04]

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
My wife uses LibreOffice to create catalogues of a couple hundred items and then converts it to PDF. Man we love LibreOffice! Anyway I set up Windows-7 and Mint-14-Mate dual boot for her to ease into Linux. Today she was ready for Ubuntu and so I did a clean install on her machine. Everything… >>> More
How do I fix these LibreOffice unmet dependencies?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The following packages have unmet dependencies: libreoffice: Depends: libreoffice-core (= 1:3.4.4-0ubuntu1) but 1:3.4.3-3ubuntu2 is to be installed Depends: libreoffice-base but it is not going to be installed Depends: libreoffice-report-builder-bin but it… >>> More
Cannot install or remove packages

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried to install the openoffice.org package but it gave an error. Now i cannot repair, remove or install nothing. The Software center of xubuntu gives this error log. Nothing seems to solve this. I tried apt-get install -f but it does not solve the problem either. Any suggestions? installArchives()… >>> More

Related posts about date

Javascript Date object expression (Date within date)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear experts, I was analyzing Javascript codes and came across this line: var date = (new Date()).getDate(); This kinda throw me off? I am pretty new to Javascript and a little curious. >>> More
Populate google.visualization.DataTable for a AnnotatedTimeLine using JSON

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a HttpHandler which returns some JSON in (i think) the correct format for a google.visualization.DataTable, but the AnnotatedTimeLine fails to work? This is the JSON returned by the Handler: {cols: [{id: 'DATE', label: 'Date', type: 'date'}, {id: 'KEYWORD51', label: 'vw cheltenham', type:… >>> More
Excel: Summing values within a certain date range (> start date and < Finish date)

as seen on Super User - Search for 'Super User'
How do I include a 'Between these dates' criteria inside a SUMPRODUCT? =Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost)) What's the way to manage dates (between) in a sum product? Thanks Mike >>> More
Extjs Date Time Picker ,HighLight particular Date instead of system date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How to highlight the particular date in extjs calender(Date Time Picker) control, As default it will highlight the system date when its shows, i need to set highlight date as sql server date. since it will be different. Is there any property or override method to change the highlight date.… >>> More
Finding date between start date and end date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I want to check whether a date is between start date and end date. i have added a where class where datepaid between '2010-04-01' AND '2010-04-15' but the problem is that it excludes '2010-04-15'. It should include end date also how can i do this? Please help me on this Regards, pankaj >>> More