Not sure if this will work, but try replacing the TODAY function with a reference to cell A1 (or any cell at the top of the page). If you manually type the date in that cell it should make the data validation trigger?
Failing that and without macros, have you considered just using an excel table? That would be easy enough to put filters on to only show ones due for testing, it's no pop up but it's quick and easy
|