You can use an Event Macro. Enter the formula just as you have posted it
(say in Z100). Put this in worksheet code:

Private Sub Worksheet_Calculate()
With Range("Z100")
If .Value = "" Then Exit Sub
.Value = .Value
End With
End Sub

As soon as the cell displays the non-blank value of NOW, the macro will
replace the formula by its static value.
--
Gary''s Student - gsnu200739


" wrote:

I am using the Now() function within a function, to enter a timestamp
as a spreadsheet is populated. Here's the function:

=IF(AND(LEN(D63)<0,MOD(B62,12)=0),NOW(),"")

The function works fine, however, the timestamp continues to update,
as I update my spreadsheet. Is there an excel function - either
preexisting within excel, or easily added - to enter a static
timestamp?