Date stamp iterative method failing

lwhyatt

New Member
Joined
May 26, 2010
Messages
29
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?
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

lwhyatt

New Member
Joined
May 26, 2010
Messages
29
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
Joined
Mar 26, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
  2. MacOS
  3. Mobile
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,310
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top