inserting datestamps

[Shane Sauter]

I have a cell that changes from "In Process" to "Completed" once a series of
tasks have been completed in the worksheet. Once that cell changes to
"Completed", I need another cell to generate a date stamp, and then never
change thereafter. Been trying circular references using the following
formula =IF(C34="Completed",IF(I34=0,TODAY(),I34),"0"), however I continually
get either 1/1/1900 or nothing at all as the result.

Open to any ideas.

Thanks.

 

[Niek Otten]

http://www.mcgimpsey.com/excel/timestamp.html