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

Thomas -

I may share your malady and I couldn't resist spending a few minutes on 
this :-)

'Anno' means 'year'. I don't know what  'Arke' means and I don't see 
where the variable is defined, but it's used as the 2nd argument of the 
WEEKNUM function. That argument is either 1 or 2, and presumably 'Arke' 
corresponds to the selection (on the Intro sheet) of Sunday or Monday as 
the first day of the week.

- Robert

On 2026-01-15 05:01, Thomas Blasejewicz wrote:
> 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