LibreOffice Calc (12): create a schedule
In this video, I create an updateable schedule. I used the MATCH, DATE, WEEKDAY, DATEMONTH, YEAR, TODAY, and CONCATENATE functions. I also used conditional formatting.
The formula for writing the first day of the January box is:
=DATE($AC$1;MATCH(B4;$Sheet2.$A$1:$Sheet2.$A$12;0);1)-(WEEKDAY(DATE($AC$1;MATCH(B4;$Sheet2.$A$1:$Sheet2.$A$12;0);1);2)-1)
The link to the calendar video: • LibreOffice Calc (11): creare un calendario
You can download the original file created in the video here: https://drive.google.com/file/d/1uQUR...