Your formula will work all day because Excel evaluates TODAY as the
same date all day. When you open the file the next day Excel will
replace the date in A1 with the current date, and change the cells that
depend on cell A1.

One workaround for this is to copy the cells in question, and Paste
Special them back over those same cells as values. This replaces the
formula with the value of the formula.