Date Sequence Identification Problem

I have a data table which consists of testing results for multiple locations. The relevant columns are: Master ID, Sample Point ID, and Collection Date. There can be multiple Sample Points per Master ID, and multiple dates per Sample Point ID.

I have a filtered list of Master ID/Sample Point ID. Now I need to find Collection Dates for these sites that match the following parameters:

Each Sample Point needs to have collected in each Calendar Quarter, but the samples must be spaced between 2-4 calendar months apart. Days and years are ignorable.

However, each sample point may have more or less than 4 samples.

I need to identify which site have sampled appropriately (by listing the sample dates), and which are missing data. Ideally I would like to know partially filled sample points, if say that 3 samples fit the criteria.

What is the best way to identify an appropriate sequence of dates for each Sample Point?

Examples:

A March sample and an April sample are not compatible (3 and 4 are not an allowable pair, even though they are in separate quarters, they are outside the 2-4 month range).

A January sample and a June sample are not compatible (1 and 6 are not an allowable pair, as they are outside the 2-4 month range).

A January sample excludes a December sample from being accepted, because they are consecutive calendar months.

A March sample excludes an October sample from being accepted (because they are 5 calendar months apart.

My initial approach was to get an array of the unique month numbers for that master ID & sample point ID, then compare to a table of acceptable sequences to find a match. Then identify which sequence matched to search for results containing those month numbers (for that ID/sample point). But there are 35 possible acceptable sequences, and this brute force started feeling like the wrong approach.

Thanks!

EDITS AS REQUESTED:

Version is Excel 365

Example Source data:

Example output: