i got stuck with my event sheet and need help.
I want to write a formula that looks if dates of guest are between dates of an event and give the right event number to the right person.
| Last Name | First Name | Start | End | Event ? |
|---|---|---|---|---|
| Spider | Man | 13.10.2021 | 14.10.2021 | |
| Tom | Cruise | 14.10.2021 | 16.10.2021 | |
| Bruce | Wayne | 12.10.2021 | 14.10.2021 |
| Event | Start | End |
|---|---|---|
| Red | 13.10.2021 | 14.10.2021 |
| Blue | 14.10.2021 | 15.10.2021 |
CodePudding user response：
I guess that you are in Deutschland. Try
=textjoin(char(10);"";query(G:I;"select G where H<=DATE'"&TEXT(D2;"yyyy-MM-dd")&"' and I>=DATE'"&TEXT(C2;"yyyy-MM-dd")&"' ";0))
