First, goto ToolsOptions and on the Calculation tab check the Iteration
checkbox to stop the Circular Reference message, and use this formula in B2

=IF($A$2="",B2,NOW())

--
__________________________________
HTH

Bob

"Dan" wrote in message
...
Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.

I do not want to use vba but rather use a circular reference in Formula.

Many thanks.

Dan