Not inside a formula.

What do you want in B2?

If today A2 equals "Yes" you want the date in B2?

If tomorrow A2 < "Yes" what do you want to see in B2.........nothing?

If next Thursday A2 goes back to "Yes" should value of B2 change to that date?

I think you will have to resort to event code.


Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 16:03:00 -0700, Date Less
wrote:

use CTRL key + ; inside a formula to put the static date in B2 If a2 = YES

if(a2="yes",today(),"blank") the date changes I want to replace today() with
CTRL ;