Thanks for your prompt response Stefi, I might have guessed. I was using the
suggested formula over 15 years ago in a DOS based fully integrated (word
processor, database & spreadsheet) software program. Perhaps Microsoft will
catch up one day !!!
Regards
Ron


"Stefi" wrote:

I'm afraid you cannot solve this tasks with formulae, you have to create a
Change event macro for it!

Regards,
Stefi


€žRon@Buy€� ezt Ã*rta:

I need to automatically date stamp a two column entry and retain the date.
The formula in column C could be =IF(AND(A10,B1=0),TODAY(),NOCHANGE) This
would result in the date appearing in column C when an entry is made in A1
and the date holding when an entry is made in B1 - how simple. Except there
isn't a function like NOCHANGE available. (this would also be the perfect
solution for killing circular references and reiterations in a single cell)
So, can anbody please advise how I can achieve the same result from a
formula using the available functions in Excel?