Hi, I am trying to create a time stamp so I can track how long a project takes to go from one step to another. 

After formulas failed I went to VBA. I inserted a module with the code:

Function MyTimestamp(Reference As Range)

If Reference.Value <> “” Then

MyTimestamp = Format(Now, “mm/dd/yyyy hh:mm:ss”)

Else

MyTimestamp = “”

End If

End Function

This works great except whenever I close the excel file and reopen it all the timestamps update to the current date and time. 

Is there a formula I can use that will not do this?

​Hi, I am trying to create a time stamp so I can track how long a project takes to go from one step to another.  After formulas failed I went to VBA. I inserted a module with the code: Function MyTimestamp(Reference As Range)If Reference.Value <> “” ThenMyTimestamp = Format(Now, “mm/dd/yyyy hh:mm:ss”)ElseMyTimestamp = “”End IfEnd Function This works great except whenever I close the excel file and reopen it all the timestamps update to the current date and time.  Is there a formula I can use that will not do this?  Read More

​