Ask Your Question

2018 calendar

asked 2017-12-26 22:23:09 +0200

Raoul.Morganti gravatar image

for libre office calc

edit retag flag offensive close merge delete




Not sure if this is a question or what it really means. Have you looked at Calendar Creator 2.0 template? See it here.

Ratslinger gravatar imageRatslinger ( 2017-12-26 23:38:45 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-02 03:20:39 +0200

hjek gravatar image

updated 2018-06-02 03:22:49 +0200

I think this question is actually pretty clear, even if brief.

In some cell, type the date you want to start from, eg 01/01/2018, or NOW(). Then in the cell below (or to the right, if you prefer), enter =A1+1 to get the next day (and fill this in the rest of the column, optionally breaking it (and changing the cell reference)). Then set the Format code in the Cell Formatting (CTRL + 1) to something like NN D MMM YY, so you can see the name of the weekend. And if you want to print this, maybe Format -> Rows -> Height and increase to 3 cm or so. If you want a monthly calendar, you can just use the formula =DAYSINMONTH(A1)+A1 instead. To have visible grid, make sure Grid is enabled in Sheet; or perhaps add borders instead.

edit flag offensive delete link more


Why the down vote?

hjek gravatar imagehjek ( 2018-06-07 15:46:39 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2017-12-26 22:23:09 +0200

Seen: 782 times

Last updated: Jun 02 '18