Need Help with Airtable

I have an airtable sheet that I need help with some logic. I have multiple dates (start date, graduation date, end date), and I have yes/No fields such as - IS THIS PERSON enrolled. I need a calculation or automation to run that says if DATE is between start date and end date - mark this field YES, otherwise NO. and similar outcomes.

Must no airtable well and able to start immediately.