Dynamic calendar for parenting time

[CigarBuddha]

I have a dynamic calendar setup and want to have it show the days each parent has and show the holidays. With that in mind the holidays change as one will have an odd year one will have an even year. The way the schedule is set one parent has Monday and Tuesday one parent has Wednesday and Thursday then every other weekend starting on Friday. If at all possible some of the dates need to have times associated with them like from 10am on that holiday to 10am the next day.

 

[Dave Patton]

If you want a calendar for 2 years, try the following

Calendar 2024.xlsx
	A	B	C	D	E	F	G	H	I
1	Sun	Mon	Tue	Wed	Thurs	Fri	Sat	2 Years	01-01-24
2	31-Dec-23	01-Jan-24	02-Jan-24	03-Jan-24	04-Jan-24	05-Jan-24	06-Jan-24
3	07-Jan-24	08-Jan-24	09-Jan-24	10-Jan-24	11-Jan-24	12-Jan-24	13-Jan-24
Sheet1

Cell Formulas
Range	Formula
A1:G107	A1	=CalendarFor2Yrs(I1)
Dynamic array formulas.

Lambda Functions
Name	Formula
CalendarFor2Yrs	=LAMBDA(Date,VSTACK({"Sun","Mon","Tue","Wed","Thurs","Fri","Sat"},SEQUENCE(106,7,WORKDAY.INTL(Date+1,-1,"1111110"),1)))

 

[Dave Patton]

for Easter

Calendar 2024.xlsx
	A	B
1	Year
2	2023	Sun 9-Apr-2023
3	2024	Sun 31-Mar-2024
4	2049	Sun 18-Apr-2049
5	2079	Sun 23-Apr-2079
6
Easter

Cell Formulas
Range	Formula
B2:B5	B2	=FLOOR(DATE(A2,5,DAY(MINUTE(A2/38)/2+56)),7)-34+(A2=2079)*7

 

[CigarBuddha]

Yes, you will need to add the dates of the upcoming years to the tables, especially for holidays like Easter, which falls on a different date every year.
Just add dates to the tables

OK I've been trying to figure out how to apply your formula into the dynamic calendar I had already made. I have my calendar setup to show the correct days for years all the way to 2040. The dates that stay constant meaning they never happen on a different date I have set they will change the year when it changes. The dates that have different dates I will have to setup so they show correctly as the year changes.

 

[GunsofBrixton]

This has been so helpful to me, but I'm stuck in two places on the conditional-rules blue/orange calendar. First, I can't figure out how to tweak the Parent_1/Parent_2 formulas to "swap" the weekends while also preserving the holidays. Second, is there a way for me to adjust the formulas so that I can see more than one month at a time? (E.g., all of 2025). All help appreciated!

 

[felixstraube]

Here is the modified file:

ParentingCalendarYear.zip

Let me know if this works for you.