See answer in your original thread.

--
Regards,
Tom Ogilvy


"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.