If you mean that you have a formula that have a date from another sheet and
if the date of the other sheet changes you want the date of the formula cell
only to change if another cell is Y? That won't work given the restrictions
with regards to iterations etc..


--


Regards,


Peo Sjoblom





"Ricke" wrote in message
...
I have a worksheet that gets a date from another worksheet and displays it
in
a cell.
I want it to only update if another cells value is "Y", If the cells
value
is "N", I want it to leave the displayed date the way it is and not update
the date from the other sheet. I have used an "IF A1=Y(formula)" but it
doesn't leave the exsisting date displayed. I don't want to use iterations
either because that would affect the other formulas I think.
Any suggestions gratefully accepted.