You would have to compare "Now()" against the date in question and open
the file that contained it occasionally.

rouennais wrote:

Is there a way to have Excel automatically notify me when a date is
approaching or has passed?