GANTT Chart - Mark cells within Date range

Hello everyone!

This is a scribble of how my tables look like:

Task/Person Table
---------Task1, Task2, Task3,..START.,....END....;
PersonA;.yes.,...no...,..yes..,22.05.21, 12.07.22;
PersonB;..no.,...no...,..yes..,22.07.21, 02.03.23;
PersonC;.yes.,...no...,..yes..,23.09.21, 25.09.21;


Task/Date GANTT Table (X = Blue field)
---------September,Oktober,November,December,.....
Task1;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Task2;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Task3;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


People have the skill for a particular task, or not (yes/no). This is assigned in the upper table. At the same time, this upper table assigns when a person is available (START; END).

The GANTT diagram (lower table) assigns tasks to the calendar. So I need to determine the following: Is there any person who is available on the given date (= within START; END interval) and who can fulfil the task ("yes") at the same time.

This is my (obviously wrong) Formula:
= AND(D$7 >= upperMatrix!$N5; D$7 <= upperMatrix!$O5)


Does anyone can help me out?
Thank you very much!!


EDIT: In the File, a person is not only able to do a task or not (yes/ no), a person can do a task Okay (Stufe 1) up to Good (Stufe 3). So understand it like this:
[Stufe 1, Stufe 2, Stufe 3] = "yes"
[Empty cell] = "no"

And the "Mitglied Von" = START; "Mitglied Bis" = END

Hello hennair and Welcome to Excel Forum.
It seems to me that the person's name would need to be taken into consideration in order to know whom was available.
In the attached file I have added a drop down for names in cell A4
The formula for cells D10:BG20 is:

Formula:

Please Login or Register  to view this content.

Note that to hide the numeric values cells D10:BG20 are custom number formatted: ;;;
The formula for conditional formatting is: =D10>0 (fill = green)
Let us know if you have any questions.