Work calendar to display several people

[sparky2205]

Hi folks,
I have a very nice calendar which was supplied to me by a colleague.
This calendar displays a list of tasks and blanks out the days on the calendar where those tasks are active.
I'm attaching some screenshots and also the calendar via Xl2bb.
The list of tasks are populated on Sheet1 and the calendar is on a sheet named Calendar.
There are a few helper formulas which are normally hidden, which I have made visible just to make it easier.
This all works fine.

What am I looking for?
I would like the calendar to be able to display the tasks by person for a variable number of people.
i.e. there are a number of people performing these tasks and I want to be able to look at any month and be able to see who has time available and who is fully booked.
So, much like the calendar currently is but each day would display a variable list of people who have tasks assigned for that day.
Right now the calendar would work very well if each of the people had their own calendar.
But the request is to have all people displayed on one calendar.
I was going to include a screenshot of what it would ideally look like but when I tried to put that together I couldn't come up with a decent design that wouldn't involve completely redesigning what is already there.
I'm hoping one of you guys will have an idea of how what I'm looking for might be best achieved.

The current calendar:

Sheet 1: (contains no formulas or CF, just text)

Tech Group Calendar.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			7			1				Start Date		End Date
2		Month	July		Year	2023				01-Jul-23		31-Jul-23
3
4		Sun	Mon	Tue	Wed	Thu	Fri	Sat		Date	Task	Status	Comments
5		25	26	27	28	29	30	01		13/07/2023	MOC-COS-CHK-12345	WIP	0
6		02	03	04	05	06	07	08		14/07/2023	MOC-COS-CHK-12345	WIP	0
7		09	10	11	12	13	14	15		15/07/2023	MOC-COS-CHK-12345	WIP	0
8		16	17	18	19	20	21	22
9		23	24	25	26	27	28	29
10		30	31
Calendar

Cell Formulas
Range	Formula
C2	C2	=TEXT("1/"&C1&"/2023","MMMM")
F2	F2	=2022+F1
J2	J2	=DATEVALUE("1-"&C2&"-"&F2)
L2	L2	=EOMONTH(J2,0)
B5:H10	B5	=SEQUENCE(6,7,DATEVALUE("1-"&C2&"-"&F2)-WEEKDAY(DATEVALUE("1-"&C2&"-"&F2),1)+1)
J5:M7	J5	=FILTER(Sheet1!A:D,(Sheet1!A:A>=Calendar!J2)*(Sheet1!A:A<=Calendar!L2),"No Tasks")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B5:H10	Expression	=AND(COUNTIF(Sheet1!$A:$A,B5)>0,TEXT(B5,"MMMM")=$C$2)	text	NO
J5:M85	Expression	=$L5="Pending"	text	NO
J5:M85	Expression	=$L5="WIP"	text	NO
J5:M85	Expression	=$L5="Complete"	text	NO
B10:H10	Expression	=DAY(B10)>20	text	NO
B10:H10	Expression	=DAY(B10)<20	text	NO
B5:H10	Expression	=TEXT(B5,"MMMM")<>$C$2	text	NO

 

[awoohaw]

Do you want names inside the calendar for the days the individuals are busy?
Where is the list of names and what is their schedule?

 

[sparky2205]

Thanks for taking the time to look at this. Hopefully my graphic will illustrate what I am trying to achieve.

This represents this week on the calendar i.e. 16th Jul to 22nd Jul. This is just a mockup in Excel.

The way I see it there could be an extra column in Sheet1 holding the person's name:

This could then act as the schedule.
The names for the calendar could also be pulled from here.

I would like, if possible, that the names would appear in a list, where single or multiple selections could be made, and only those names would appear in the calendar. But that's a nice to have.

I hope that's clearer. I was having a difficult time to visualise it myself yesterday but I have a clearer picture in my head now.
If you have an idea for a different layout that will work better fell free to use it.
If you have other questions or need further information please let me know.