I think the formula posted to the Airtable blog here, under the heading " Figure out which date comes first :soon: " is way too complicated.
The formula on the blog is posted as:
IF(IF(XOR(BLANK(),{Expiration Date},{Date})=1,"",IF(OR({Date},Expirat...