It is actually a circular reference so you need to place the formula in
B1. First set iteration ToolsOptionsCalculation check the iteration box.
Then insert the formula in B1. Also if you just want the date and not
the time then I would change the formula slightly to:
=IF(A1="","",IF(B1="",TODAY(),B1))

Hope this helps
Rowan

nempo wrote:
I can't seem to get it to work. I went to that site and i insert the
code

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

I inserted it into C1, but when I have "cat" in B1 it won't display
anything until I put something into A1. Then it will paste whatever is
in B1 to C1. I want it to look at A1 and if something is inserted into
it B1 will output the m/d/year and keep that date there. I know the
site you gave me is probably correct, but I can't get it to work.
Please help thanks