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: [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
