Hi, "Anno" and "Arke" correspond to named range of cells. You can check them here.
Anno is the cell C5 in sheet "Intro" and cointains the year Arke is the cell F23 in sheet "Intro" and contains 1 if you prefer Sunday for first week day or 2 if you prefer Monday. It is white text on white backgroud, so you can't see it So, you can replace in your formulae, 2026 for Anno and 2 (or 1) for Arke: A5 -> =IF(WEEKDAY(DATE(2026,SHEET()-1,1),2)=1,DATE(2026,SHEET()-1,1),"") D5 -> =IF(WEEKDAY(DATE(2026,SHEET()-1,1),2)=4,DATE(2026,SHEET()-1,1),IF(LEN(C5)>0,C5+1,"")) Hope this helps, Luis Iglesias > De: "Thomas Blasejewicz" <[email protected]> > Para: "users" <[email protected]> > Enviados: Jueves, 15 de Enero 2026 11:01:24 > Asunto: [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: [email protected] > 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 -- To unsubscribe e-mail to: [email protected] 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
