I am looking to find a formula to show a value or text for those who have "left" if the current month is no longer listed against their name, as well as if the current month is listed they are still "active"


Dates.PNG