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?
 

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
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.
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top