Re: [libreoffice-users] Struggling to make a calendar work

Greetings,

When I created my universal calendar, I used this strategy:

1) Format each month as 6 rows (not 5) of 7 columns (a 30-day month can
span 6 weeks if the 1st is on the last displayed day of the week)
2) Display a number on a day of the week if the current day is in the
current month (hint: the date function will correctly figure out that
DATE(2025,12;32) is indeed the same as DATE(2026,1,1), so you can use
MONTH(DATE(the_year,the_month,day_of_yesterday+1)) to see if you are
still in, let's say, December). If you are not in the month anymore,
display a blank ("")
3) Display a number on a day of the week if the previous day of the
month is not blank (""). This number will be the day of the previous
day plus 1
4) Exception for the first row of the month:
4a) If the previous day is not blank (""), display a number on a day of
the week. This number will be the day of the previous day plus 1
4b) If the day of the week of the first day of the month is the current
day of the week, place a 1 in the cell, otherwise, put a blank ("")

This will ensure you are not having all the days filled with numbers.

If you want, I can also send you my version if you want to play with
it.

I hope this helps.
Rémy.


Le jeudi 15 janvier 2026 à 19:01 +0900, Thomas Blasejewicz a écrit :
> Good evening
> I have spend days and hours on end trying to create a dynamic
> calendar 
> using Calc.
> I found a sort of guide: 
> https://technical-tips.com/blog/software/libreoffice-create-calendar--so-19755
> and believe followed it to the letter to create my own calendar.
> As I said, it took me literally days to figure out, how to get the 
> automatic calculation of days and months to work.
>
> Problem: now I have a grid with 5 rows and 7 columns completely
> filled 
> with numbers,
> so that I end up with overlapping months at the end and beginning of 
> each month.
> That is not how a calendar is supposed to look.
>
> I also downloaded the "perpetual calendar" template and tried to play
> with that.
> That gives me sheets with the dates arranged as supposed, but so far
> all 
> efforts of applying that kind of formatting
> to my own calendar have failed.
> For example, the perpetual calendar template leaves three cells blank
> (formatted with conditional formatting that I also do not understand)
> to begin with January 1 of 2026 on a Thursday ->
> A5    -> 
> =IF(WEEKDAY(DATE(Anno,SHEET()-1,1),Arke)=1,DATE(Anno,SHEET()-1,1),"")
> D5    -> 
> =IF(WEEKDAY(DATE(Anno,SHEET()-1,1),Arke)=4,DATE(Anno,SHEET()-
> 1,1),IF(LEN(C5)>0,C5+1,""))
>
> When I tried to copy those formulas into my calendar (where the 
> respective cells would be A3 and D3)
> I get #REF! in all following cells
> Searching the net for "Anno" and "Arke" found in above formulars
> tells 
> me, these terms do not appear in the Libreoffice documentation
> and their meaning is unknown.
> By now I could have handwritten calendars for the next 20 years, but
> I 
> hate to admit defeat in my struggle with some piece of software.
> I do not really "need" this, but would love to understand what is
> going on.
>
> So, if anyone has a lot of free time on his or her hand to guide me 
> through this thing, I would be grateful.
>
> Thomas

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy