Formula to see if someone is available

Landon W

I am trying to build a formula that references another sheet. The goal is to be able to see if someone is working on a project currently. In the reference sheet we have the start date and end date and the Talent's name. So, I am guessing it is going to have to be a IF/AND formula and the conditions will need to include the person's name but then I am stumped. I can't figure out how to get the formula to read the date range or if it is even possible. Any help at all would be really appreciated. 

L_123

Broken down version

=count(collect(Name:Name,StartDate:StartDate,@cell <=today(),EndDate:EndDate,@cell >=today(),Name:Name, @cell = [email protected]

What yours will look like

=count(collect({Name},{StartDate},@cell <=today(),{EndDate},@cell >=today(),{Name}, @cell = [email protected]