Check out this community blog post that covers a very similar pattern using workflows with access request triggers and date-based logic, might be a helpful starting point:
Check out this community blog post that covers a very similar pattern using workflows with access request triggers and date-based logic, might be a helpful starting point: