Compare a date to an array of dates?

Try switching your column B to a rollup, and set it to MIN() instead of the default ARRAYUNIQUE() so it returns the earliest date amongst the original values.

Duplicate it (column C) and do MAX() now instead, for latest date.

You should then just be able to fashion your logic check with IF(), OR(), and DATETIME_DIFF() on these three columns (if A is less than 30 days prior to B or A is less than 30 days after C).

Hm the only way I can think to do this is with an automation I’m afraid, and I’ve set it up here for you to check out

The problem with automations is that we currently can’t compare dates dynamically, and so the idea is to convert your date data into milliseconds using DATETIME_FORMAT.  In the gif above you can see that I’ve converted 30 days before and after the set date into milliseconds, and in the ‘Dates’ table I’ve done the same:

This allows us to search the dates dynamically as they’re now just converted into numbers, and s we just do ‘If the millisecond number value is larger than the 30 days before millisecond value, etc’:

Hi,
Route the rollup value to the table, which is a source of lookups (i mean, create a lookup of this rollup). Create additional formula there, ABS(Datetime_diff, rollup value, lookup value, ‘days)). Return to your table and create the same lookup column, but with condition, where DIFF (your formula) <31