Why does A1 receive a date when you change A1?

What is in A1? Formula or?

The value in B1 is the serial number of NOW()

Format B1 to Date


Gord

On Fri, 20 Mar 2009 16:30:38 -0400, "Mark A. Sam"
wrote:

It is getting there, but not quite. I placed the formula into cell B1, but
it when I update A1, it receives that date (20/3/2009 16:21) and B1
receives an unknown value (39892.68145).


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Did you try the circular reference formula from John's site?

=IF(A1="","",IF(B1="",NOW(),B1))

Of course, after changing the Iterations setting.


Gord

On Fri, 20 Mar 2009 15:54:40 -0400, "Mark A. Sam"
wrote:

Gord.

What he is looking to do is to copy the the formula from one cell to
another. After seeing how it works, I think the coding option may be to
cumbersome for him. It will require modifying the code for each cell he
wants to target, at least that is how it seems to me. I used on cell as
an
example, but he will be addressing many cells. Am I wrong in my thinking?

What I think I need to do is modify the formula something like this:

=IF(A6="" and B6<"","",NOW())

But that doesn't work. It is illegal syntax.

God Bless,

Mark




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Mark

Couple of methods on John McGimpsey's site

One without VBA and one with.

http://www.mcgimpsey.com/excel/timestamp.html


Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 15:17:41 -0400, "Mark A. Sam"
wrote:

Hello,

I'm not too proficient with Excel so hopefully this can be done. My
client
is using this formula to update the date and time in a particular cell:

=IF(A2="","",NOW())

He wants it to update only when A2 is updated, but it updates when any
cell
is updated. Does this require a code and if so how to implement it.

Thank you for any help and God Bless,

Mark A. Sam