Conditonal Format

[TxcPhtm]

I have one cell which u can choose 3 options out on 1 of them being Done and
i want to make another cell respond to done by changing it to done aswell but
i want to be able to put a date in thereif the logical question is wrong e.g.
=IF($B$23="Done",$C$24="Done")
Whats wrong with this?

 

[T. Valko]

=IF($B$23="Done",$C$24="Done")

Whats wrong with this?

Based on your formula it looks like you want this to appear in C24.

Enter this formula in C24:

=IF($B$23="Done","Done",DATE(year,month,day))

Fill in the date parameters to suit. For example, for the date 7/4/2008:

=IF($B$23="Done","Done",DATE(2008,7,4))