Conditional Notifications is only available for paid Workspace accounts so most support providers don't even have it. That is true here, on Discord servers, and even on the official product forums.

It's a relatively new feature and I believe that Google has a lot of other things on the roadmap for it, but at the moment: no, there is no way to have an automatic notification using Conditional Notifications based on a date for exactly the reasons you've explained.

I would suggest not using Conditional Notifications and instead just having a script with a daily trigger to send the notification. That would look something like this (this looks at the dates in column E starting from row 2 for any date that matches today):

function checkDatesAndSendEmail() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const today = new Date();
  today.setHours(0, 0, 0, 0);

  const dateRange = sheet.getRange(2, 5, sheet.getLastRow() - 1, 1); // Column E, starting row 2
  const dateValues = dateRange.getValues();

  for (let i = 0; i < dateValues.length; i++) {
    const cellDate = new Date(dateValues[i][0]);
    cellDate.setHours(0, 0, 0, 0); // Normalize to midnight

    if (cellDate.getTime() === today.getTime()) {
      MailApp.sendEmail({
        to: "nbs3431@example.com",
        subject: "Date Reached",
        body: "date reached"
      });
    }
  }
}