First off, I'm running Excel 2013.
Second, I have reset my iterative calculation to MAX Iterations to 1 and Max Change to 0.
My formula is: =IF(AND(A2>=A4,C3=""),TODAY(),"")
What I am saying above is, when A2 >=A4 insert todays date in C3, otherwise stay blank. If there is a date already, do not change.
This is not working for me.
What it does, it stays blank like it should. But once the date is inserted it still changes the next day. Also, once the date is inserted when you click on the save icon it toggle from date to blank to date to blank.
What am I doing wrong here?
Thanks in advance