How can I target profiles whose membership end date falls in the month exactly 3 months from now?

Hi all,

I have a field called Membership End Date, which always contains the last day of a month.

Examples:

• 31/08/2026
• 30/09/2026
• 31/10/2026
• 30/11/2026

I need an audience containing profiles whose membership end date falls in the month that is exactly three calendar months from today.

For example:

• Today's date: 14/08/2026
• Target month: November 2026
• Expected audience: all profiles with a Membership End Date of 30/11/2026

Similarly:

• If today were 05/09/2026, I'd want all profiles ending in December 2026
• If today were 20/10/2026, I'd want all profiles ending in January 2027

What I've Tried

"In next 3 to 3 months"

This appears to return profiles with an end date of 31/10/2026 rather than 30/11/2026, which suggests it's calculating a rolling three-month period rather than the calendar month three months ahead.

90-120 day range

This works inconsistently because month lengths vary.

Rolling date ranges

I can see options for ranges such as "3 to 3 months ago", but I can't find an equivalent approach for future months.

Question

Is there a way within Audience Builder to target profiles whose date falls within the calendar month exactly three months from today's date, without creating additional calculated/boolean fields upstream?

Or is the recommended approach to derive this logic before the data reaches AEP?

Any suggestions would be greatly appreciated.

Thanks,
 Will