inserting datestamps

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sequential text and numbers problem 2
User defined function returns imprecise value when used in worksheet 3
Inserting current date when number entered in cell & Circular reference error? 4
Excel hh:mm format 6
"Chart Data Range is too complex to be displayed" 2
2 IF Statements not mutually exclusive 2
Excluding Cells based on Format (Footbal Pool) 3
MACRO PASTE CELL to COLUMN, SKIP ROWS 1

Top