Forum Discussion
Creating Timestamp Formula, Returning 1/0/1900
Google has been telling me that creating a formula that will create a STATIC timestamp is impossible. I took this as a challenge. I came up with the following formula that indexes from a separate...
Assuming that you enter this formula in A175, it causes a circular reference. Even if you turn on iterative calculation, it won't do what you want.
Google is correct - you need VBA to insert a static timestamp, not a formula.