I need to find a way to keep users from entering the formula (=TODAY())
in a cell that requires today's date.

Cell validation doesn't work because the formula produces a result
within the accepted range.

Is the anyway to "turn off" formulas in a cell?

Any help would be greatly appreciated.