You can make the formula conditional with an if statement so that it only
works for its intended purpose, or you can delete it.

"SmartyPants" wrote:

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.