Hi there. I have table with the following:
________________________
|Task Status | Date Completed|
~~~~~~~~~~|~~~~~~~~~~~~~|
Completed | 10.29.2007 |
In Progress | |
Completed | 10.22.2007 |
and the following formula:
=IF(E5=$E$1,(NOW()),"")
What I want to do is if the Task Status column (E5) has the word "COMPLETED" in it, then today's date will appear in the cell to the right. If any other word or character is inserted, the cell will remain blank. This part works fine.
The problem is that if I change the system date to another day, then enter a 'Completed' status on E6 for instance, for all other cells that have a 'Completed' entry, these dates now change to today's date.
Not sure if I explained that well. Anyway, is there a way to use the IF function, insert a date, and have it stick?
Appreciate the help, thanks!
2007-10-29
09:21:36
·
3 answers
·
asked by
Anonymous
in
Software