I noticed you have multiple people with a status of "OFF". See if you can adapt the setup in the attached file. Notice that the formula is surrounded by curly brackets. This means that it is an array formula and it must be confirmed with ctrl+shift+enter.

Book1.xlsx