Date Conditions for Sheets' new Conditional Notifications feature

I have a date column in a Google Sheet and would like to use the Conditional Notifications feature to send an email reminder 2 weeks BEFORE the date. However, when creating the rule, the only 3 conditions related to Dates (below screenshot) don't give me the flexibility I need. Am I able to use any regular expressions or other syntax there to accomplish my goal? If not, anyone have any other thoughts on how to do this (other than an Apps Script).

b_gorsky1_0-1721495815263.png

 

0 2 1,819
2 REPLIES 2
Top Labels in this Space
Top Solution Authors