Date Conditions for Sheets' new Conditional Notifications feature

[b_gorsky1]

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).

[mohssin365]

To send an email reminder 2 weeks before a specific date using Google Sheets' Conditional Notifications, you can add a helper column to calculate the reminder date. In your Google Sheet, add a new column called `ReminderDate` and use the formula `=A2 - 14` (assuming your target date is in column A) to calculate the date 2 weeks prior. Drag this formula down to apply it to all rows. Then, set up conditional formatting with a custom formula `=TODAY() = B2` to check if the current date matches the reminder date. Finally, go to `Tools` > `Notification rules`, and set a rule to "Notify me at once" when "Any changes are made" to trigger email notifications when the condition is met. This method allows you to use Google Sheets’ built-in features to send reminders without using Apps Script.

[b_gorsky1]

I was referring to Conditional Notifications not Conditional Formatting with standard email notifications.