[libreoffice-users] Struggling to make a calendar work

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