I have multiple documents that autopopulate dates into printable calendars using a formula, they’re based on an old excel template. All I have to do is update the year. So in 2023 I will change the year at the top and all the dates update in the rest of the calendar. I use this to create printable planners for myself.
The formula is basically this, it increments on each day and month
=IF(AND(YEAR(Jan)=Year,MONTH(Jan)=1),Jan, “”)
=IF(AND(YEAR(Jan+1)=Year,MONTH(Jan+1)=1),Jan+1, “”)
=IF(AND(YEAR(Jan+2)=Year,MONTH(Jan+2)=1),Jan+2, “”)
and so on for the entire year
However if the first of the month winds up being on a sunday my calendar starts with the second of the month (because it’s a Monday start calendar, instead of Sunday start).
So for example, May 2022 starts on a sunday
so on a Sunday Start Calendar it will populate:
S M T W T F S
1 2 3 4 5 6 7
And on a Monday Start calendar it will populate:
M T W T F S S
2 3 4 5 6 7 8
I’m not sure how to get the formula to work with a Monday Start Calendar.
From what I’ve read so far this has to do with a regional standard. I have one calendar print out the week numbers next to each week of the month and I got that to work w/Monday start by using ISOWEEKNUM instead of WEEKNUM. However, pretty much everything else I do is US based so changing the standard for the app or system would not be a good idea.
Edit: I am using LBO 7.2.1 on Windows