I would suggest some type of event code that adds a static timestamp rather
than have a formula-derived one which is difficult to keep static.
But you can prevent a formula from updating using worksheet functions alone.
Couple of methods on John McGimpsey's site
One without VBA and one with.
http://www.mcgimpsey.com/excel/timestamp.html
Gord Dibben MS Excel MVP
On Sun, 31 Jan 2010 14:18:01 -0800, camperguy7
wrote:
Ive been trying to use an if statement to put a static date in a cell when a
certain condition is met. I do not want that date to change(update when the
workbook is opened in the future) how can this be done??