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.