Date stamp

[laxster]

How can I convert this into being a static date stamp? It does what I need it to do, but when that particular field is a zero, I need to be able to have a static date stamp when that happens. I've found a few posts about static date stamps, but none of them are very useful. Any idea how?

=IF('bin capacities'!J3=0,NOW(),"")

 

[chergh]

You need vba for this which triggers when the cell J3 changes to 0 and uses the now function to write the value to a cell. There are lots of examples of this about.