Formula to see if someone is available

Landon W
Landon W ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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.