# Date stamp iterative method failing

#### lwhyatt

##### New Member
I'm using the formula:

=IF(E3<>"",IF(K3<>"",K3,NOW()),"")

to date stamp in K3 when an entry in E3 is made. I have itterative calculation enabled to 1000 iterations. I have formated K column to date.

However, whatever I input the date 00/01/1900 is returned.

What am I doing wrong to get this method to work?

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### lwhyatt

##### New Member
I should add, if I delete the figure currently in E3, then add it back in again it works. I want it to do nothing to the contents of K3 until a new figure is typed into E3, overwriting what is currently there.

#### w0kkie

##### New Member
Hi @lwhyatt, I realize this is an old post now but came across it in a search and noticed no answer was shared, so thought I would share what I learned by looking for something similar, which may be what you're looking for. Give it a try (place the code in cell K3, based on your parameters above):

Code:
``=IF(E3<>"",IF(AND(K3<>"",CELL("address")=ADDRESS(ROW(E3),COLUMN(E3))),NOW(),IF(CELL("address")<>ADDRESS(ROW(E3),COLUMN(E3)),K3,NOW())),"")``

* Also, there should be no need to set iterations to 1000, unless you need that for a different purpose. Even using 1 iteration would work for this kind of calculation where it is just a logical operation and not a numerical/mathematical one, and might avoid you having a long wait if you accidentally include a circular reference in a complex formula somewhere down the road.

Replies
3
Views
383
Replies
3
Views
94
Replies
8
Views
361
Replies
11
Views
3K
Replies
3
Views
1K

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,596
Messages
5,832,640
Members
430,150
Latest member
amitk1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back