I'm trying to figure out how to build a formula with this logic. When a person is listed on a row with start and end dates, are they listed again for an upcoming event in the next week? Is it possible to create a formula that gives a yes/no answer. Or gives a count of how many times a person is listed in the next week? Or can half of the logic be built in a formula and the other half in automation filters?
08/18/20 08/20/20 Person 10
08/18/20 08/20/20 Person 11
08/18/20 08/20/20 Person 12
08/25/20 08/27/20 Person 13
08/25/20 08/27/20 Person 8
08/26/20 08/28/20 Person 9
08/25/20 08/27/20 Person 2
08/24/20 08/24/20 Person 2
08/26/20 08/28/20 Person 11
09/01/20 09/03/20 Person 5
09/04/20 09/04/20 Person 5
09/01/20 09/03/20 Person 9
08/31/20 09/02/20 Person 3
09/01/20 09/03/20 Person 10
Thanks for your help!