I would use a macro instead of an equation. The macro could continuously
monitor D8 and, when it exceeds 1, set the date/time in a static fashion.

The form of the macro depend on whether D8 is calculated or manually entered.
--
Gary''s Student - gsnu200851


"Shaun" wrote:

How do I stop my formula =IF(D81,NOW(),€�€�) from updating every time I open
the document? I am using this formula for a form that is filled out
electronically; I am using this formula with a locked cell so that the date
and time cant be modified. If I save the document and then reopen it
refreshes every time I do. How can I stop this from happening?