I have a calendar that uses just one formula. It works well, except I want to adapt its height according to the number of days shown.
For example, at present, the calendar will consistently be six rows deep. For those months that don't have any days in the final row, the sixth row should not return. I still want the days that fall in the next month to show, but only if they are on a line containing days for the current month.
As you can see, for December 2021, the sixth row is redundant because those are all for January 2022.
Screenshot 2021-11-25 at 10.57.20.png
Another example is if February has 28 days and the first of that month is Monday, only four rows should show.
Screenshot 2021-11-25 at 10.55.16.png
Bookmarks