inserting datestamps
 

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.

inserting datestamps
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Shane Sauter" <Shane wrote in message
...
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.