Cell Restrictions still
 

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.

Cell Restrictions still
 

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.

Cell Restrictions still
 

See the suggestion in your original thread - why keep posting the same
question over and over.

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